Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 10

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

  • syedtufailshah Profile Picture
    syedtufailshah 10 on at
    Re: PowerAutomate to search for users v2 with filtering and update and create data in sharepoint list

    @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.

  • syedtufailshah Profile Picture
    syedtufailshah 10 on at
    Re: PowerAutomate to search for users v2 with filtering and update and create data in sharepoint list

    @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.'.'.

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: PowerAutomate to search for users v2 with filtering and update and create data in sharepoint list

    SudeepGhatakNZ_0-1703757916805.png

    SudeepGhatakNZ_1-1703757977484.png

     

    SudeepGhatakNZ_2-1703758044515.png

     

     

  • syedtufailshah Profile Picture
    syedtufailshah 10 on at
    Re: PowerAutomate to search for users v2 with filtering and update and create data in sharepoint list

    @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.

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: PowerAutomate to search for users v2 with filtering and update and create data in sharepoint list

    @syedtufailshah ,

     

    Please try this

    SudeepGhatakNZ_0-1703750832352.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard