Skip to main content
Community site session details

Community site session details

Session Id : /ya8cQnLwdPJ+kdTPMyCae
Power Automate - Building Flows
Answered

Is it possible to update a CDS lookup field based on a CDS text field?

Like (0) ShareShare
ReportReport
Posted on 18 Apr 2019 17:48:48 by

Is it possible to update a CDS lookup field based on a CDS text field?  I tried doing this but keep getting the error "Bad Request".

 

My flow goes as follows:  When a CDS record is created--> Update CDS record.  Then I update the lookup field ("TestLookupField") based on the text field ("Current Situation").

 

 

cds.PNG

  • Verified answer
    v-bacao-msft Profile Picture
    on 19 Apr 2019 at 03:30:15
    Re: Is it possible to update a CDS lookup field based on a CDS text field?

    Hi @Anonymous ,

     

    If you want to update the Lookup column, we need to configure this field using the Entity Id in Related entity.

    For example, if there is a Lookup column in Entity A that is associated with the field in Entity B, then we need to update the Lookup column with the Entity Id of Entity B containing the corresponding field value.

    Please take a try.

     

    Best Regards,

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2