Answered

Need help with implementing delete feature in Power Automate flow for SharePoint list and distributed group

(0) Share

Report

Posted on by rswain

173

I have a distributed group that contains many users. Additionally, I have a SharePoint list with two columns called Name and Email, which retrieves all users from the distributed group and stores them in the SharePoint list using Power Automate. However, I want to automatically delete users from the SharePoint list whenever they are deleted from the distributed group. I have already designed a flow that is working perfectly, but I don't understand how to implement the delete feature. Can you please help me?

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (1)

HenWang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rswain ,

I think you can add below logic to your flow after the "apply to each 2" action. Your create item part is perfect and for deleting the item, you need to compare each item in SP list with each item in group members, and if the result is no, then it means the current item in SP list is actually deleted in Azure ad group, and you need to delete this item.

For the get items 2 action, please do not use any filter query so that flow can loop each item inside the list.

For the condition 2 action, I used the title dynamic content which contains the email address value, you can also compare the name value from your side.

Hope this can help.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
rswain 173 on at

Like (0)

Report
Copy link

Link copied!

Hi @HenWang ,
Thanks for your time.
I have tried the same but I am getting error during flow execution.

Was this reply helpful? Yes No
rswain 173 on at

Like (0)

Report
Copy link

Link copied!

Even its deleting my all records in the list

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I think there is something wrong in delete item action, can you show me the screenshot of the delete item action details?

Was this reply helpful? Yes No
rswain 173 on at

Like (1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rswain ,

Truely sorry for that. Please refer to below logic:

And then, please refer to this :

Formula inside the condition control:
length(variables('If_No')) //left
length(outputs('Get_group_members')?['body/value']) //right

This logic would help to complete your flow.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
rswain 173 on at

Like (0)

Report
Copy link

Link copied!

I have updated the same logic. However, the flow is now working successfully, but the user is unable to delete from the SharePoint list.

Was this reply helpful? Yes No
rswain 173 on at

Like (1)

Report
Copy link

Link copied!

@HenWang Any chance to look into this ?

Was this reply helpful? Yes No
Verified answer

HenWang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rswain ,

Yes, there are two places to improve:
1. empty the string variable VerifyUsers after your condition 3 action:

Just set it to null formula.

2. If the result is still not correct, you can consider using toLower formula to both of the email address in your condition action:
For example, I will use below formula for the group mail dynamic content:
toLower(items('Apply_to_each_2')?['mail'])

which would be toLower(items('Apply_to_each_3')?['mail']) in your flow.

Hope this helps.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
rswain 173 on at

Like (1)

Report
Copy link

Link copied!

It's now working like a charm Thanks for your time .

Was this reply helpful? Yes No