Answered

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

All responses (5)

Answers (1)

Verified answer

abm abm 32,506 Most Valuable Professional on at

Like (1)

Report

Re: Checking a Sharepoint List for Similar Entries

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
abm abm 32,506 Most Valuable Professional on at

Like (1)

Report

Re: Checking a Sharepoint List for Similar Entries

Hi @Anonymous

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

Like (0)

Report

Re: Checking a Sharepoint List for Similar Entries

When I try to split I get both entries are false but Testing Well_Comp should be true.
abm abm 32,506 Most Valuable Professional on at

Like (1)

Report

Re: Checking a Sharepoint List for Similar Entries

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.
abm abm 32,506 Most Valuable Professional on at

Like (1)

Report

Re: Checking a Sharepoint List for Similar Entries

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