Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

How to find the GUID of a related table row using the name lookup?

(0) ShareShare
ReportReport
Posted on by 76

I have an automated flow running that creates an event booking triggered when a contact field "webform" is populated.  The flow creates the event booking I want created, applying fields from the contact table but I want to link the event booking to the event, which is a separate Dynmaics custom table.  I have the name of the event booked in a text field "webform" in the contact record but am stuggling to find a way to lookup this name field against the Events table and return the GUID of the Event record to write into the event booking lookup field.

 

I beleive I should be using Get Record but struggling to find how to apply this to my (hopefully simple) situation.

 

I know that the event name text field is unique and the same as the event name in the Event table as that is sorted in another process, so no danger of duplicate event names!

 

Can anyone point me in the right direction please?

  • Nettsales Profile Picture
    76 on at
    Re: How to find the GUID of a related table row using the name lookup?

    @ViditGholamgot it - many thnaks

  • Verified answer
    VIDIT Profile Picture
    666 on at
    Re: How to find the GUID of a related table row using the name lookup?

    Hi @Nettsales you are on the right track just the table name is incorrect use that name which is not editable just in plural form.

    ViditGholam_0-1617714135697.png

    salesorders

    cus look up basically means you are looking into many records and not just a single one

  • Nettsales Profile Picture
    76 on at
    Re: How to find the GUID of a related table row using the name lookup?

    @ViditGholamahhh... so there are three possible names for a table - name (salesorder) display name (Order) and Plural name (Orders) but it's none of these rather "salesorders"

     

    Will give this a go now - thanks.

  • Verified answer
    VIDIT Profile Picture
    666 on at
    Re: How to find the GUID of a related table row using the name lookup?

    hi @Nettsales check this out

    ViditGholam_0-1617713350698.png

  • VIDIT Profile Picture
    666 on at
    Re: How to find the GUID of a related table row using the name lookup?

    use events instead of event and that might work 

    i have got this error 1000 times now😂 and the solution to this is use plural names

  • VIDIT Profile Picture
    666 on at
    Re: How to find the GUID of a related table row using the name lookup?

    your table name might be wrong don't use singular names 

    like generally it is invoice but for lookup it is invoices

  • Nettsales Profile Picture
    76 on at
    Re: How to find the GUID of a related table row using the name lookup?

    That is what I thought I needed and had done but I keep getting this error:

    Nettsales_0-1617711941544.png

    Which makes me think I had missed a step somewhere...

  • VIDIT Profile Picture
    666 on at
    Re: How to find the GUID of a related table row using the name lookup?

    hi @Nettsales  user /entity plural name (Record(value))

  • Nettsales Profile Picture
    76 on at
    Re: How to find the GUID of a related table row using the name lookup?

    hi @ViditGholam - correct.  Then I want to add this to a lookup field in the Event booking table

     

  • VIDIT Profile Picture
    666 on at
    Re: How to find the GUID of a related table row using the name lookup?

    You should get the guid from the list rows it self 

    Even if it the count is one it will still get you to an apply to each

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >