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
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 filtering to this URL at the moment it’s just one filter for one list web part h
Thanks Matt
