Find duplicates and check for Property

[FoxMulder]

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?

[danielbazetto]

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.

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.