Answered

Updating Created by works for most items in SharePoint, but fails on some with "We couldn't find an exact match"

(0) Share

Report

Posted on by meggrace

Hi, I have a SharePoint list that has a People or Group column that pulls from a particular SharePoint group that has a list of employees. It works for the majority of the items perfectly, but there are 5 employees that it fails on with "We couldn't find an exact match".

My code is:

Why is it failing for just 5 employees? Thank you in advance for any guidance.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

To troubleshoot, can you add a Get User Profile (V2) action into the Apply to Each loop to see if the user can be retrieved with their email address?

Was this reply helpful? Yes No
meggrace 11 on at

Like (0)

Report
Copy link

Link copied!

Hi - thank you for the quick response. I added a Get user profile(V2) for Created by Email, and it successfully pulled my information, as I am the one who created the items.

I also manually typed in the email address replacing Created By Email with one of the employees it is failing on for exact match, and it returned their profile information.

Was this reply helpful? Yes No
creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

Sorry, I should have been a bit more clear with my instructions. I used the Created by Email dynamic content as an example. What I meant to ask you to try is to use the dynamic content that you are using in your Compose action in place of the Created by Email dynamic content I used in my test.

I'm assuming that whatever dynamic content you've inserted here is what is pulling the user's email address.

Can you confirm if you are using a Person column in your SharePoint list? Or is it a text field.

The Get user profile (V2) action requires the email entered to match the email stored in the User's profile. For example, if you are entering in an email address in all lowercase, but the email address in the User's profile is stored in camel case, it will not return anything.

Was this reply helpful? Yes No
meggrace 11 on at

Like (0)

Report
Copy link

Link copied!

Hi - sorry that I misunderstood. Yes, when I use the same dynamic content as in my compose statement in the Get user profile (v2) statement, it does pull the profile information for that employee. That column is a Person or Group field type that is using a SharePoint group.

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!

No worries. If it does pull the profile of the employee, can you use the Mail dynamic content from the Get user profile (V2) action in your Compose action where you set the claims? Give that a try.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No
meggrace 11 on at

Like (0)

Report
Copy link

Link copied!

The issue was totally human error, as the managers did not mark their employees as on leave, or terminated (garbage in, garbage out!). So, the employees do exist in the SharePoint group, but show as disabled when pulling the Get User Profile (v2). Thank you very much for your help @creativeopinion and pointing me in the right direction to look at the user profile properties.

Was this reply helpful? Yes No