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 :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / How to get the Lookup ...
Customer experience | Sales, Customer Insights,...
Suggested answer

How to get the Lookup record Name In Power Automate??

(0) ShareShare
ReportReport
Posted on by Himanshu Kamboj 421

Hi ,

I have a Power automate for case entity and my requirement is to get the lookup fields record name to send the email to users.

My flow is getting trigger on create and update of case.

pastedimage1674135118481v1.png

Above attached SS I want to get the Opportunity and account lookup record name without using the "Get a Row by Id".

Like I want he record name Opportunity = Test  and Account = modem. 

Is it possible to get these name of lookup records without using "get a row by id". 

I have the same question (0)
  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 10,409 Super User 2025 Season 2 on at
    RE: How to get the Lookup record Name In Power Automate??

    Hello  Himanshu Kamboj,

    Yes we can get the lookup name using the formatted value of lookup field. Please refer below article which will help you to implement your requirement.

    softchief.com/.../

    powerusers.microsoft.com/.../1396670

    Thank you,

    Amit Katariya

  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,489 Moderator on at
    RE: How to get the Lookup record Name In Power Automate??

    Hi Himanshu Kamboj,

    It doesn't seems to be possible. You have to use "Get a Row By Id" to get names of account and opportunity.

    Upon trigger of flow fetch the same case record and then with help of formatted value syntax you can access account and opportunity.

  • Suggested answer
    CRMJetty Profile Picture
    CRMJetty 3,512 on at
    RE: How to get the Lookup record Name In Power Automate??

    Hello Himanshu Kamboj,

    For Power Automated Process if you used Lookup field name then you must be call "Get a Row by Id" Method on trigger or in Process. By using this you get your value or you can say Formatted value.

    For Row by ID you can used this method : https://www.c-sharpcorner.com/article/get-lookup-field-text-in-power-automate/

    I hope it helps,


    Thanks.


    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Portal.

  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 10,409 Super User 2025 Season 2 on at
    RE: How to get the Lookup record Name In Power Automate??

    If you only need the lookup name then you can get easily from case payload. But if u need more information from the related entities then u will have mention in expand query parameters.

    Please refer below article which will help you to implement your requirement without use to get record by id connector.

    dynamicsbackpage.wordpress.com/.../

    Thank you,

    Amit Katariya

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 258

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 179

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 128 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans