Unanswered

Lookup column value from sharepoint list based on Form response and assign it to a variable

(1) Share

Report

Posted on by andyvt

Hi,

I am building a Flow where the "Office Location" drop down menu in my Form will determine who the form response data will get emailed to. I also have a sharepoint list called "LocationsList" with two columns. Column A has office locations and Column B has employee email addresses. I want the selection in the Form for "Office Location" to lookup the location in Column A and then retrieve the associated Column B email address and then dump that into a variable. I have the variable and rest of the email flow working, and just need to figure out how to get the "Office Location" seection from the Form to lookup the Column B email in the sharepoint list.

I also can get this to work Control function statements but it takes a LOT of them to cover all of the 50+ office locations and the flow gets really big and messy. Hoping these is a simpler way to do this.

Anybody know how to do this?

Thanks,

Andy

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (1)

Report

Hi @andyvt
According to your description, you want to get the email in the Sharepoint list according to the result of the Office Location selection in the Form.
If any misunderstanding, please kindly let me know.
I have set up a simple flow you can refer to:
This is my test list
This is my test From
Flow in details
Get the item from list which ColumnA is equal to the Office Location from From.
Get the value of ColumnB in this item
When a new response is submitted as below:
Will get the email corresponding to Location2
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
andyvt 8 on at

Like (0)

Report

Hello @v-LilyW-msft ,

Thank you for the reply. I think you have understood correctly my intention for this flow.
I have been testing this and not able to get this working.
Here is my form:

Here is the Sharepoint list:

Here is the flow:

I am not able to get the email to come through. Am I setting the variable correctly?
Also, on the Compose step within the Apply To Each step, how do you get the "OUTPUT" field to appear and what does this do?

Thanks.

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

Hi @andyvt
I tried to reproduce your scenario with variable but it works fine for me.
The role of Compose in my above solution is just to show the results.
In fact, you don’t need to set variables. If you want to send an email, just add send an email action at the end as below.
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
andyvt 8 on at

Like (0)

Report

Hi all,
Thanks for your replies. I rebuilt the entire flow and it worked after that. I must have had some error somewhere in my original attempt. The replies above are all good. Thanks!

Was this reply helpful? Yes No