
I am having an issue with what is probably a very basic task!
I have a questionnaire in Forms, with a list field which includes 'Company'.
When I receive a response, I would like to use Power Automate to send an email address according to the company selected.
Ie. If a person selects Company A, I want an email to be sent saying "please contact [reception@CompanyA.com]"
I am having an issue linking the lookup table to the variable from Forms.
I'm sure it's an obvious solution that I am overlooking but any help is appreciated!
There is no Lookup function in Power automate the way there is in Power Apps. But for most things you can use a Get Items with an Odata query to select the record. Then use first() to get the first record returned. That's the equivalent of a Lookup.