I have a flow that I am building that looks up if a person/group column in a SharePoing List is in a SharePoint group and if they are not in the SharePoint list then remove them from the SharePoint group. However, I can't seem to get the condition to come back as true.
Here you are using get items and prior to the apply to each loop- But what we can do is call the get items action inside the loop by applying the Odata filter query.
See below
Here i am looping through the results of send http request using apply to each loop and inside that using the get items - flow is trying to filter the items whose admin is equal to current iterating person's details.
Here OData filter query is used to filter results in get items action.
Now next use a condition which checks items are retrived from the get items action as shown below
Expression:
length(outputs('Get_items')?['body/value'])
This condition checks whether the output from get items is empty or not- if empty it means specified person in group does not exists in sharepoint list and if yes - you can add action in yes branch to delete the person details from the group.
Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
13
Share
Report
All responses (
Answers (
