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

sharepoint flow - check 2 lists

Hi,

 

I'm new in sharepoint-flows , and i need some help if it's posssible :

- i have 2 lists : list1 and list2

- list1 has a column "serialnumber1"

-list2 has a column " serialnumber2"

 

what i want , when a new item it's added in list1 , to check "serialnumber1" if exist in list2 in "serialnumber2".

 

thank you in advance!

3 REPLIES 3
Highlighted

Re: sharepoint flow - check 2 lists

You can query list 2 using the get items action. Make sure that you set filter on the get items action.

 

For more details please see the following post:

https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/

Highlighted
New Member

Re: sharepoint flow - check 2 lists

already tried with "get" , it works if something exists in list number 2.

but if list nr2 it's empty, i can't do any actions

Highlighted

Re: sharepoint flow - check 2 lists

You will need to add a condition in your flow so that on empty you can run some actions.

 

An exmaple of the condition need you can find here:

 

https://veenstra.me.uk/2018/12/03/microsoft-flow-import-list-data-from-an-excel-spreadsheet-into-sha...

 

 

 

 

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,839)