Flow to check if sharepoint item entry exists in another sharepoint list

(0) Share

Report

Posted on by Community Power Pla...

Hi All,

I'm building a "check in" tool.

List A is populated with the data from our engineers, this comes from a MS Form
List B contains all of our locations that engineers can check into

I'm looking to build a daily occurrence flow that will look at the location reported and added into List A, then compare against List B to inform of which locations did not receive a check in. The results should be populated into CSV and emailed out.

Can anyone help with this?

Thanks,

Tom

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

sudharsan1985 1,325 on at

Like (0)

Report

Hi @Anonymous
Please follow the below steps and try if it solves your problem
1. Get the items from the locations list
2. Once you received all the master locations. Initialize an array variable to store the locations not checked in.
3. Iterate through all the locations from the master and check whether the items are there in List A. Check the length of the items, if it is less than or equal to 0 then you can add that location to the array variable declared above and using that array variable you can send the list in an email.

4. Make sure you use the correct filter query by accessing the lookup field.
5. After the 'Apply to each' action, you can get the final array of locations that are not checked in.

Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
-Sudharsan K...

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Could you please post a screenshot of your Sharepoint lists A & B? Also the relevant column data types and some data as well.

Thanks

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

@Anonymous just the last part you can't do, becouse you need to create a table to populate data, so you can't use csv

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi abm,

Lists are below...

List A: Location = Single Line of Text
List A - Data populated from MS Forms

List B: Site = Single Line of Text
List B: Static Data, only changed when sites are opened / decommissioned.

What i would like to achieve is when the daily flow runs, it gets the Sites from List B and then reviews the submissions on that day in List A, looking in the Location column for a match, the output into a CSV table would look like:

Location Checked_In Date
Loc1 No MM-DD-YYYY
Loc2 Yes MM-DD-YYYY

I can do the next bits of sending an email with the CSV file attached (the easy bit :))

Thanks,

Tom

Was this reply helpful? Yes No