Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Because I can't get my column updated with api rest.

(0) ShareShare
ReportReport
Posted on by 210

I don't understand why I can't get my column updated with api rest.
below the capture of the flow

Snag_9fe430.png

MAJ_ANC = text column

CLoture_instruction = date column

The flow runs correctly but the columns remain empty

An idea ?

  • Ulysse4733 Profile Picture
    210 on at
    Re: Because I can't get my column updated with api rest.

    When I create an item in my B list, I have a column (ANC ID) itself filled in from a feed. I want to retrieve its value to put it in the MAJ_ANC column of my list A. But I have to do "a get the properties" to be able to retrieve it because when creating the element in list B this ID_ANC column is empty ...
    thank you I learned a lot thanks to you, especially by reading your post and your advice

  • Ellis Karim Profile Picture
    11,122 Super User 2025 Season 1 on at
    Re: Because I can't get my column updated with api rest.

    Please examine and post the content of outputs('Créer_un_élémen_dans_registre_ANC_(CR)')

     

    This is the variable you are using to reference body/ID_x0020_ANC .

     

    Ellis

     

     

     

  • Ulysse4733 Profile Picture
    210 on at
    Re: Because I can't get my column updated with api rest.

    If I remove the question mark here is the error

    Snag_1636840.png

    I am therefore in the case stated at the end of your article (very well by the way). But I don't quite understand. the ID_ANC column does exist in my list

  • Ellis Karim Profile Picture
    11,122 Super User 2025 Season 1 on at
    Re: Because I can't get my column updated with api rest.

    Hi   @Ulysse4733 

     

    (1) Please share the value of:

    Snag_22f29689.png

     

    (2) Please remove the '?' QUESTION mark from the expression, then re-run the flow to see if it generates an error message. Please share any error messages.

     

    The expression is generating a null or empty value:

    outputs(Créer_un_élémen_dans_registre_ANC_(CR)')?['body/ID_x0020_ANC']))

     

     

    When using the [BRACKET] notation with a QUESTION mark, if there is no value to assign to a key (.e.g.  ['body/ID_x0020_ANC']) it will be treated as null .

    For more info about this, please see How to query JSON data using JSON notation with Power Automate


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as ☑️ Solved.
    If you like my response, please give it a Thumbs Up.
    My Blog Site

  • Ulysse4733 Profile Picture
    210 on at
    Re: Because I can't get my column updated with api rest.

    OK, thanks,
    I had this error code because of the format. I had read elsewhere that the month had to be put first. it's not true

    What about the concat column?(the second point  update a column with concat('text',dynamic fields)

  • Ellis Karim Profile Picture
    11,122 Super User 2025 Season 1 on at
    Re: Because I can't get my column updated with api rest.

    Hi @Ulysse4733 ,

     

    (1) Make sure you are using the internal name of the columns in the HTTP request

    🔍How to find the internal name of a SharePoint column

     

    (2) Check the Uri

    I have the follow sample code working (my regional settings are UK):

    Snag_20ec6a22.png

    Snag_20fd5510.png

     

    Snag_20f264c5.png

    (3)  Please check the runtime Output section of the HTTP action for any errors:

    Snag_20f528e7.png

     

    Snag_20f0f42e.png


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as ☑️ Solved.
    If you like my response, please give it a Thumbs Up.
    My Blog Site 

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

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!

Announcing the Engage with the Community forum!

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

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1