cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Greyfox
Frequent Visitor

Reference filtered SharePoint list URL in SharePoint item

Hi,

 

I am a newbie flow user trying to build the following flow ( sorry can't provide screenshots as it has sensitive information)

 

All steps are for SharePoint flow actions:

 

1) when an item is created or modified 

2) get item

3) condition step= check if column A of item contains 'ABC' and column B contains 'DEF'

4) if yes, get items, filter for 'ABC' in column A and 'DEF' in column B

5) update item, in abstract field, concat abstract from step 1 with filter generated from step 4 as a hyperlink that reads click here for historical data

 

I am not able to perform step 5..am I missing some in-between steps. 

 

 

 

 

 

 

 

 

 

 

 

 

3 REPLIES 3
Campbell22
Helper I
Helper I

Hey @Greyfox,

 

What are you trying to accomplish with this flow what is the end result? I am a bit confused on step 5, I do not fully understand what you are trying to do or why, could you please explain further. 

 

I have replicated your flow on my end and you do not need the Get Item action as you can use the dynamic content from your trigger instead.

Campbell22_0-1623383426085.png

 

Additionally SharePoint does not offer a way to view previous results or changes from items that you can access in Power Automate. The closest thing we have is native to SharePoint but we can not access that in flow unfortunately.

 

Campbell22_1-1623383761385.png

 

Please provide more information on your requirements and I am happy to help.

 

Cheers

Campbell

Greyfox
Frequent Visitor

Hi @Campbell22 

 

Many thanks for the reply.

 

The SharePoint list hosts an archive of events from multiple organizations [for eg. Column A = ‘ABC’] with multiple event related tags [for eg. Column B = ‘DEF’]. Each event also has an abstract with manually added text.

 

I add 20 new events everyday to the archive and distribute them to specific users with an abstract and link to title via email, which is autogenerated using SharePoint. When they click on the title, they can view details of Column A and Column B for that particular event in SharePoint.

 

I want to create a flow so that each of the 20 abstracts have a hyperlink at the end, which redirects users to a filtered view of the SharePoint list depending on that event. For eg. ‘Column A = ABC’ and ‘Column B = DEF’. I want the hyperlink to read ‘Click here for historical event data’.

 

Back to my flow, I was able to filter the database with the condition of Column A and Column B. I want to use this filter output as a hyperlink in the abstract.

 

Thanks for the tip for removing ‘Get Item’.

 

Thanks,

Fox

Campbell22
Helper I
Helper I

Hey @Greyfox,

 

Sorry for taking so long to get back to you.

 

As of now I do not believe their is a way to create a SharePoint view in Power Automate (see link below).

https://powerusers.microsoft.com/t5/Building-Flows/Build-flow-that-create-new-view/td-p/377386

 

The only way I could think to get around this issue would be to manually create a bunch of views and filter them based on the content that you want displayed and then in Power Automate we can use that link to the SharePoint list view so users can see all the items for that view. 

 

E.g. If an item is created with Column A = Completed and Column B = ABC manually create a view and filter the items to only show if Column A = Completed and Column B = ABC. Then using a switch we can filter and based off that result we can add the given link for that items view. 

 

This would be a lot of set up work depending on how many options you have but technically possible.

 

I am happy to walk through this solution with you but potentially could be a lot of work to setup, but once setup it should all work smoothly.

 

 

Cheers 

Campbell

 

_____________________________________________________________________________________________________________________
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,691)