Creating a flow using data from 2 sharepoint lists

[User1vanessa]

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 

[abm · Accepted solution]

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/