Answered

How to match a name between SharePoint and Microsoft Forms and then after finding the matched name row input a column into a variable

(0) Share

Report

Posted on by Rupin

Hello everyone, the title might be confusing but let me make it clearer with images. So, I have a flow where I take the responders email from Microsoft Forms, and then I put it into get user profile. After I put it into get user profile, I want to match that name with a name from one of the SharePoint lists I have, which has a bunch of names and their director's. So, whoever the user is, I want to find their director and then put their email inside a variable. Below are the images for what I have.

Sharepoint:

so, the image above shows that both staff name and director are person or group columns. And I try to match the display names for both and want the email of the director for the person who submitted the form.

So, in the image it is taking the responders email and getting the user profile and that user profiles name is inside a variable. Then I try to get the matched user and then put that matched user's director inside a variable. However, I am pretty sure its wrong. So, any help would be appreciated.

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

@Rupin Instead of using an Apply to Each and Condition action. It's much more efficient to use a filter query instead.

You will need to use the internal column name of your user profile column. If you aren’t sure how to get this, please refer to this section of one of my YT tutorials. In my case, it's 'Profile'. Add a forward slash and EMail. Use eq for the equals to operator and between single quotes insert the Responders' Email dynamic content.

You can add a Compose action after to check to see if any items have returned by using the length() function.

Click on the Dynamic content tab and insert the value output from the Get Items action.

You can then add a Condition action to determine what happens if there are no items returned, or if there are.

I can't tell from your screenshot what you are doing with the variable. However, it might not be necessary in your scenario. If you could provide a full screenshot of your flow it would help.

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
Rupin 63 on at

Like (0)

Report

@creativeopinion Thanks for your answer! For the variable I was trying to send an approval process to the director and the variable had the director's email because it's a person or group column inside SharePoint

Was this reply helpful? Yes No