Get "Office 365 users" report and add output to Sharepoint list if not exist

[vipfafen]

Hi Guys,

I start with a "Office users 365" evaluation and would like to transfer the output to a Sharepoint list, but only if the entry (Username or Mail) does not already exist

I am stuck at the transition to the Shapreoint.

[FreddieV]

I do a similar check for an onboarding process to see if what their eventual email will be is already taken:

The check expression is: length(outputs('Search_for_A303_account')?['body/value'])

Basically, if the output is blank (the user doesn't exist) it eventually goes on to create the account. It looks like you need to create a condition in your flow.

[vipfafen]

Thanks for the feedback, maybe I expressed myself wrong.

The goal is, to feed my sharepoint list with the output of "Apply to each" (Office 365 users and assigned Manager)

[FreddieV · Accepted solution]

I see. Apologies, you did say you were stuck on the transition to Sharepoint. There is a Sharepoint card > Create Item is the card that you will want, in that case.

[vipfafen]

Thank you FreddieV,

one more question. How to take care for duplicates or existing entries and exclude them from the creation?