cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vipfafen
Frequent Visitor

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

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.

 

Screenshot 2020-12-07 185144.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

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.

View solution in original post

4 REPLIES 4
FreddieV
Resolver I
Resolver I

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

 

ss.png

 

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.

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)

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.

Thank you FreddieV,

 

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,571)