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
Super User

Re: Checking a Sharepoint List for Similar Entries

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

View solution in original post

5 REPLIES 5
Highlighted
Super User
Super User

Re: Checking a Sharepoint List for Similar Entries

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
Highlighted
Super User
Super User

Re: Checking a Sharepoint List for Similar Entries

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
Highlighted
Frequent Visitor

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. 4.PNG5.PNG6.PNG7.PNG

Highlighted
Super User
Super User

Re: Checking a Sharepoint List for Similar Entries

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
Highlighted
Super User
Super User

Re: Checking a Sharepoint List for Similar Entries

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

View solution in original post

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,350)