Lookup between ms forms and sharepoint

[Mishatandon]

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?

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

[v-bacao-msft · Accepted solution]

Hi @Mishatandon ,

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

Best Regards,

[Mishatandon]

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?

[v-bacao-msft]

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.

Best Regards,

[Mishatandon]

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.

[v-bacao-msft]

Hi @Mishatandon ,

Please try the following method:

toLower(outputs('Compose'))

Best Regards,

[Mishatandon]

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