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.

View solution in original post

Thank you FreddieV,

 

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,170)