cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mishatandon
Helper III
Helper III

Lookup between ms forms and sharepoint

Dear community,

 

I am creating a flow to seek approval from a 'person responsible' value which is hosted on a sharepoint list column. I am not able to look up values between the person who has submitted the response with the same person details on the sharepoint list to fetch ' Person responsible' values to whom the approval will be sent.

How to tackle the look up between MS forms and fetch relevant approvers from sharepoint list?

Flow 1.pngFlow 2.pngFlow 3.png

Attaching the flow I have build which doesnt seem to work 😞

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @Mishatandon ,

 

If the Person responsible field only allows single selection, maybe you could refer to the following configuration:

27.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
v-bacao-msft
Community Support
Community Support

 

Hi @Mishatandon ,

 

If the Person responsible field only allows single selection, maybe you could refer to the following configuration:

27.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-bacao-msft ,

 

This is working like a charm but only 1 exceptions. 

 

So the response on forms captures the responder email is - Misha.Tandon. To resolve the exception I did:

 

I tried creating a variable - Small with initial value of the responder email.

I the set the variable -  tolower('Small')

Then in the step mentioned by you for condition , put in output of the variable = column of Sharepoint list.

 

But its not working, anything I am doing wrongly?

 

Hi @Mishatandon ,

 

I don't understand what you mean, email does not contain a domain? Can you provide more instructions and Flow run history?

 

Also, you could try to use Search for user action to get the email of the user.

33.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-bacao-msft ,

 

Sorry for complicating things, i will try to explain it in a simple manner.

 

Responder email value from MS forms is coming as Misha.Tandon@abc.com

where as in sharepoint column I have value of misha.tandon@abc.com

 

So the condition is not meeting , so how to lowercase the value from MS forms? I did to lower as explained above but its not working. I only need to convert it to lower case and then do a comparison.

 

 

 

Hi @Mishatandon ,

 

Please try the following method:

44.PNG

toLower(outputs('Compose'))

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-bacao-msft ! this resolved the issue.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,286)