How to remove users from my Sharepoint list that are no longer found in 0365 database using Power Automate

[MelB10]

I have a Sharepoint list that holds members of a Teams Channel and updates when a new member joins. How can I create a flow that updates my Sharepoint list to show that this member no longer exists as they have either left the Teams channel or the company.

[v-chenzhi]

Hi @MelB10 ,

Do you want to delete the items without cations in O365?

Could you please tell me the type of columns in SharePoint?

I assume you have a column named TTPerson type of Person.

Here is the flow.

Here is the expression:

result('123')[0]['status']

Best Regards,

Zhi Chen

[MelB10]

Thank you so much for your response @v-chenzhi 

I'll try this and let you know how it goes.

Regarding  the TTP, I have a title field that shows the users email address. 

I added a column that has a yes/no choice to test if its working correctly as I was worried to just delete but perhaps I'll set up a test SP list as you've shown and do it this way.

Thanks again. 

[MelB10]

Hello @v-chenzhi, I don't have a column called TTPerson. I would like to remove users that are invalid when searched for through 0365, (as they have left the company).

The Expression
"result('123')[0]['status']" will therefore not work as my columns are not set up this way. 

These are the type of columns I have currently:
Title (Email Address)
Microsoft Teams Member (Yes/No Column)
Joined MS Teams (Date Column)
Left MS Teams (Date Column)

Thank you.

[v-chenzhi · Accepted solution]

Hi @MelB10 ,

Do you want to remove the items (If this email cannot be found by Get user profilesV2, then delete it)?

Please try the following workaround.

I create a column type of text.

result('Scope')[0]['status']

Best Regards,

Zhi Chen

[MelB10 · Accepted solution]

Thank you, your solution works perfectly! Much appreciated.