Skip to main content

Notifications

Community site session details

Community site session details

Session Id : L6xukuzt7pz+IPqOgMvBi4
Power Automate - Building Flows
Unanswered

Reference filtered SharePoint list URL in SharePoint item

Like (0) ShareShare
ReportReport
Posted on 10 Jun 2021 19:09:14 by 2

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. 

 

 

 

 

 

 

 

 

 

 

 

 

  • Community Power Platform Member Profile Picture
    on 16 Jun 2021 at 05:12:17
    Re: Reference filtered SharePoint list URL in SharePoint item

    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.

  • Greyfox Profile Picture
    2 on 11 Jun 2021 at 05:59:18
    Re: Reference filtered SharePoint list URL in SharePoint item

    Hi @Anonymous 

     

    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

  • Community Power Platform Member Profile Picture
    on 11 Jun 2021 at 03:58:26
    Re: Reference filtered SharePoint list URL in SharePoint item

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 51

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 37 Super User 2025 Season 1

#3
Chriddle Profile Picture

Chriddle 21 Super User 2025 Season 1

Overall leaderboard
Loading started