Unanswered

PowerAutomate to search for users v2 with filtering and update and create data in sharepoint list

(0) Share

Report

Posted on by syedtufailshah

Hi,

I'm trying to create a flow which will search users office 365 and than apply a filter array to filter all those users which has a jobtitle and if there is no jobtitle with any user than ignore that record. (it is bringing system accounts also)

Than i want to add those users, name, email, accuntenabled?, jobtitle in a sharepoint list.

also it should update the information if a user already exists in sharepoint list and if not exists than add that user information in the list.

can some one suggest the flow with screenshot would be really helpful.

Regards

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@syedtufailshah ,

Please try this

Was this reply helpful? Yes No
syedtufailshah 10 on at

Like (0)

Report
Copy link

Link copied!

@sud
many thanks Sudeep for creating the flow.
Can you please attach each control values what you have configured. eg "Job title is not null" what value to put for select an output from previous steps. etc
Would be really helpful to see all the controls.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
syedtufailshah 10 on at

Like (0)

Report
Copy link

Link copied!

@SudeepGhatakNZ
hi Sudeep i am getting below error while running the flow. i have also attached my all flow

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Apply_to_each' at line '1 and column '1006' cannot reference action 'Get_items'. Action 'Get_items' must either be in 'runAfter' path or within a scope action on the 'runAfter' path of action 'Apply_to_each', or be a Trigger.'.'.

Was this reply helpful? Yes No
syedtufailshah 10 on at

Like (0)

Report
Copy link

Link copied!

@SudeepGhatakNZ
hi Sudeep, now that error is fixed and the flow is running since 30 minutes but data is not getting populated in sharepoint list. attached screenshot.

Was this reply helpful? Yes No