cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Florin1
Level: Power Up

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
Super User
Super User

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/

Florin1
Level: Power Up

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

Super User
Super User

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

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 326 members 5,715 guests
Please welcome our newest community members: