web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Basic lookup question

(0) ShareShare
ReportReport
Posted on by

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!

 

 

 

 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,678 Most Valuable Professional on at
    Re: Basic lookup question

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard