cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Find duplicates and check for Property

Hi all,

 

i'm working on a SharePoint list that will have some Flows associated to it. Main purpose is to control the function of teams meeting recording.

 

The SharePoint list  does contain columns for receiving user and the meeting date. The flow for the activation (adding user 36 hours before meeting to enablement group) is working fine. I'm struggling with the removal flow.

 

The point is that i need to check the complete list for duplicate entries of the receiving user, and need to check if there still is a planned meeting for this user. If not, than the user can be removed from the group. So, if all meeting dates, for an receiving user, are older than current time, remove the user from the group.

 

I tried to sort this out with array(s) but wasn't able to find a solution, anyone here who can help?

1 REPLY 1
Microsoft
Microsoft

Hi @FoxMulder ,

 

I am not sure in what exact step you are stuck, if you could share perhaps images showing where are you now and how you are trying to make that cross check that could be helpful.

 

In one of my own flows where I was checking if a user was duplicated in a SPO list, I use the a condition setting a an expression to analyze, if the response received in the previous step was empty it means that the user was not on the list, if it was not empty it means that the user was already on the list.

danielbazetto_0-1594278163967.png

 

The expression was something like this:
empty(body('Get_response_details')?['r85d17a16b0464d56bf0677c5a0fd345c']) is equal to true

That "r85d17a16b0464d56bf0677c5a0fd345c" was the information retrieved on the response from the previous card.

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (8,255)