Skip to main content

Notifications

Power Automate - Using Connectors
Answered

CDS Update Record returns status 400

(0) ShareShare
ReportReport
Posted on by 103

Trying to  update and existing record in a custom entity returns status 400: No resources were found when selecting for update

The Record with the given ID exits in the db.

Categories:
  • Strahlemann Profile Picture
    Strahlemann 16 on at
    Re: CDS Update Record returns status 400

    You can only use "CDS update record" when the key value, you are searching against, is actually defined as the Primary Key in the CDS Database settings.

    Screen Shot 2017-11-14 at 15.26.50.png

  • mcorning Profile Picture
    mcorning 332 on at
    Re: CDS Update Record returns status 400

    I just found the same issue. screenshots follow.

     

    Flow errorFlow error

    CDS record to update (note correct RecordId)CDS record to update (note correct RecordId)

  • DieterA Profile Picture
    DieterA 103 on at
    Re: CDS Update Record returns status 400

    Tested this with Standard and custom entity.

     

    The workorund using the PrimaryId field as the Record Id is working.

     

    The answer took so long because i ran in another isssue with lookup fileds adn the overall slow web interface at the moment

  • DieterA Profile Picture
    DieterA 103 on at
    Re: CDS Update Record returns status 400

    The MyContact Entity was only for testing and is deleted.

    At the moment i use the standard contact entity.

    But i tested with diffrent entities and flows.

     

    But as mentioned in my other post the workorund using the PrimaryId field as the Record Id seems to work.

     

     

    Usimg the ReordID filed as Record Id results still in the erros.

     

    I will setup an sync flow for one of our SQL Tables.

    I will the post further feedback.

     

  • DieterA Profile Picture
    DieterA 103 on at
    Re: CDS Update Record returns status 400

    I don't no if i missed somethig yesterday or something has changed.

     

    I creadted a new Flow using the PrimaryId field as the Record Id and it is working.

     

    So we can use this as workaround.

     

    Usimg the ReordID filed as Record Id results still in the erros.

  • Vijeta Profile Picture
    Vijeta on at
    Re: CDS Update Record returns status 400

    Can you please share screenshots of your flow and also the MyContact entity fields? I am assuming you are trying to update MyContact entity record. Thanks

  • DieterA Profile Picture
    DieterA 103 on at
    Re: CDS Update Record returns status 400

    manually entering the value of an exiting reords returns also error 400

  • DieterA Profile Picture
    DieterA 103 on at
    Re: CDS Update Record returns status 400

    Using the primary ID results in the same error 400

  • Verified answer
    Vijeta Profile Picture
    Vijeta on at
    Re: CDS Update Record returns status 400

    Hello DA,

     

    Sorry for the delay. As a workaround can you please try to provide the value of PrimaryId field as the Record Id field input for the update action?

  • evel Profile Picture
    evel on at
    Re: CDS Update Record returns status 400

    Hi @DA

     

    I wasn't able to reproduce your issue, and I've escalated your question to some folks who might be able to know more. Sorry about the long wait time. Hopefully we'll be able to work together to solve your issue. 

     

    Thanks, 

    -evel

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard

Featured topics