Unanswered

Find SharePoint item based on another field value

(0) Share

Report

Posted on by SBAYXX

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 😞

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

SwJ23 85 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
SBAYXX on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No