cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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 blog

Power Automate Video Tutorials

View solution in original post

5 REPLIES 5
Highlighted
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 blog

Power Automate Video Tutorials
Highlighted
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 blog

Power Automate Video Tutorials
Highlighted
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

Highlighted

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 blog

Power Automate Video Tutorials
Highlighted
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 blog

Power Automate Video Tutorials

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (11,840)