cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Noah1625
Frequent Visitor

Checking a Sharepoint List for Similar Entries

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. 

 

112233

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User III
Super User III

Hi @Noah1625 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

5 REPLIES 5
abm
Super User III
Super User III

Hi @Noah1625 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
abm
Super User III
Super User III

Hi @Noah1625 

 

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.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Noah1625
Frequent Visitor

When I try to split I get both entries are false but Testing Well_Comp should be true. 4.PNG5.PNG6.PNG7.PNG

abm
Super User III
Super User III

Hi @Noah1625 

 

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

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
abm
Super User III
Super User III

Hi @Noah1625 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (29,178)