URL List Filtering
-
Im trying to create a URL to a page on my site which when used will enter the page and filter a column in a list that’s displayed. I started by taking the basic URL (below) and then filtering the list and copying the new URL (STANDARD URL)https://eurodev.sp.ema.emersonprocess.com/sites/users/mcloran/SitePages/Fisher.aspx(Filtered URL)https://eurodev.sp.ema.emersonprocess.com/sites/users/mcloran/SitePages/Fisher.aspx#InplviewHash418c97ba-d2e7-48a0-ae05-d89b7252df76=WebPartID%3D{957BA999--F89C--4921--9761--36813C20F083}-FilterField1%3DBusiness%255Fx0020%255FUnit-FilterValue1%3DFisher This works if I copy and paste the new URL into my browser, however I have another issue. The reason I need the URL is because I have another list which has a workflow. The workflow starts when a new item is created and it takes a value from the new item and uses this to construct a URL. It uses a build string {Common:WebUrl}/SitePages/{ItemProperty:Business_x0020_Unit}.aspx Saves this as a variable (linkvar) And then sets a field in the item to this created hyperlink i.e. set field link to linkvar Basically when a new item is created in the list, the workflow looks at what the business unit field of the item is and then creates a URL to the page of that business unit on my site. This works fine. But what I want to do is add the filtering part to this URL. I realised that it would be easier to have one page for all business units, and just have the lists/webparts on this page filtered/set up for different business units dependent upon the link used to access that page. I know that views could be used for this, however, I would have to create the views myself, and overtime more and more business units will come on-board and I won’t be around to set them up. The new link would look something like {Common:WebUrl}/SitePages/{ItemProperty:Business_x0020_Unit}.aspx#InplviewHash418c97ba-d2e7-48a0-ae05-d89b7252df76=WebPartID%3D%7B957BA999--F89C--4921--9761--36813C20F083%7D-FilterField1%3DBusiness%255Fx0020%255FUnit-FilterValue1%3DFisher The bold ‘fisher’ is the value to filter the list to. I will probably remove the red lookup and just have a link to a generic all business units page. However, when I set my workflow up with the added text the set field part fails. I think it because it doesn’t recognises the added text as a hyperlink and the field it’s trying to set into is a hyperlink. I think this is just a URL syntax issue could anyone help??? Overtime I will want to add additional f