cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
User1vanessa
New Member

Creating a flow using data from 2 sharepoint lists

I need to create notifications based on data from 2 sharepoint lists.

From the first list, I want to determine whether a project is close or open… The column value options are “yes” or “no”.

 

From the second list, I want to match all the open projects by project name. (Project name is available on both lists.)

I need to determine if the project is connected to a claim… in which case, the name of the claim will appear in a column called Claim Driver.

 

If there is indeed a connection to a claim, I want to send an email notification to the owner of that Claim.

If there is no claim, then I would like to send an email notification to the manager.

All email contacts can be found on the second list.

Thank you 

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @User1vanessa 

 

You need to use SharePoint ODATA filter to retrieve records related to project is Yes . Then using the results again do another filter to match the project and get the claim.

 

Have a look at the below links related how to filter SharePoint list records

 

https://www.youtube.com/watch?v=G6VsL5zVYtc

 

https://tahoeninjas.blog/2019/07/03/using-the-sharepoint-getitems-action-in-flow/

 

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

1 REPLY 1
abm
Super User
Super User

Hi @User1vanessa 

 

You need to use SharePoint ODATA filter to retrieve records related to project is Yes . Then using the results again do another filter to match the project and get the claim.

 

Have a look at the below links related how to filter SharePoint list records

 

https://www.youtube.com/watch?v=G6VsL5zVYtc

 

https://tahoeninjas.blog/2019/07/03/using-the-sharepoint-getitems-action-in-flow/

 

https://sharepains.com/2018/11/12/sharepoint-get-items-odata-filter-query/

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,512)