Unanswered

Checking a Sharepoint List for Similar Entries

(0) Share

Report

Posted on by Community Power Pla...

I am trying to make a flow that will check if a piece of equipment at a certain place has been checked in the last 3 days. If there has been no new entry for the equipment in the last three day then it will send an email reminder to whoever last made the entry. I am trying to compare two array variables. One concatenates the columns wellname, equipment, and authors email for entries made 3 days ago and the other concatenates wellname and equipment for entries made less than 3 days ago. I want to compare the two and filter out any items that share equipment and wellname. Any help would be greatly appreciated.

123

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

In your first array you have concatenates wellname, equipment, and authors email and the other array you have concatenates wellname and equipment. To compare both it would be better to concatenate with a delimiter (-, or _ or 🙂 in both names.

So you first array will be wellname -equipment-authors email and second array will be wellname -equipment

Then in your IF condition you could do a expression split with the delimiter character to match the exact match.

Thanks

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

Like (1)

Report

Hi @Anonymous

Another option is your Select action step split into two columns. First with wellname and equipment only. Next store the emails. So that when you compare you could compare with same format in both arrays.

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

Like (0)

Report

When I try to split I get both entries are false but Testing Well_Comp should be true.

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

Like (1)

Report

Hi @Anonymous

Thanks for your reply. Can we do a screen share? I am available next 20 minutes. Email the details.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

Thanks for the screen share. Just to recap this is what we did.

1. Filter by Date

2. Collect the result sets in an array

3. Duplicate the same array again

4. Iterate both arrays to find the duplicate values (Combination of two columns from array)

5. Filter the original array matching result from step 4.

Thanks

Was this reply helpful? Yes No