Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Find SharePoint item based on another field value

(0) ShareShare
ReportReport
Posted on by

Hi

My flow is evaluating whether a user is existing in a sharepoint list. If the user does not exist, it is created. If it exists, i would like to update the existing Sharepoint item, but how do i find that item, when I only have the User ID from the Search For User V2 function. I write this value to a column called Used ID in the SharePoint list when initially creating the user.

 

My filter query does not work 😞

SBAYXX_1-1673470236533.png

 

 

  • grantjenkins Profile Picture
    grantjenkins 11,057 on at
    Re: Find SharePoint item based on another field value

    @SBAYXX I'm not sure why you have an Apply to each in your Yes branch and a Get items within that loop. I believe you would just need the Get items without the Apply to each (probably the reason your flow is taking so long).

     

    Are you able to show your entire flow? There might be a slightly easier way to build it to get what you are looking for.

  • SBAYXX Profile Picture
    SBAYXX on at
    Re: Find SharePoint item based on another field value

    Great - thanks, that fixed it! Unfortunately it takes forever to run, 20+ mins for creating or updating 40 users. What did i do wrong? The Array contains all existing User IDs from sharePoint.

    SBAYXX_0-1673476396511.png

     

  • SwJ23 Profile Picture
    SwJ23 85 on at
    Re: Find SharePoint item based on another field value

    Your filter query column name cannot have spaces in it. 

     

    Please go to your list, click the cog in upper right, then list settings, then the column, then look at the url ending for the columns real name. 

     

    See below:

     

    Screenshot 2023-01-11 at 3.17.28 PM.png

    Screenshot 2023-01-11 at 3.18.15 PM.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,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard