web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Dynamically referencin...
Power Automate
Unanswered

Dynamically referencing a key column in update a row option

(0) ShareShare
ReportReport
Posted on by 14

Hi, I created a table and added a key column in to the table. Now I want to use the added key column in my update row, but im not able to do so. Can anyone help me with this issue or suggest any other alternative for it. Thank you.

Screenshot 2023-07-11 205131.pngScreenshot 2023-07-11 205027.png

 

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    on at

    Hi @yeagerman ,

     

    Please try to click 'Enter custom value' button and enter the column name which was created in above steps.

    vxiaochenmsft_0-1689125951965.png

     

    Best Regards,

    Wearsky

  • yeagerman Profile Picture
    14 on at

    sorry that didnt work, could u share any other method?

  • v-xiaochen-msft Profile Picture
    on at

    Hi @yeagerman ,

     

    Is there an error message? Please share some information or screenshots.

     

    Best Regards,

    Wearsky

  • yeagerman Profile Picture
    14 on at

    It shows me this.

    yeagerman_1-1689136358246.png

     

     

  • v-xiaochen-msft Profile Picture
    on at

    Hi @yeagerman ,

     

    Please input the text directly rather than using dynamic content.

    vxiaochenmsft_0-1689139786966.png

     

    Best Regards,

    Wearsky

  • yeagerman Profile Picture
    14 on at

    I tried it, but then im not getting any items to update.

    yeagerman_1-1689151316492.png

    i had tried this, but then none of the cells are getting updated.

    yeagerman_2-1689151407926.png

    Do u have any solution for this problem? if yes could you share it. thank you.

     

  • v-xiaochen-msft Profile Picture
    on at

    Hi @yeagerman ,

     

    Before updating the row, could you check if the row exists?

    Let's say you have created a new column (Meal Prep) in excel table by using 'Add a key column...' action.

    In next step, let's say the key column is set to 'Meal Prep' and the key value is set to 'value1'. 

    Does this item with 'value1' exist?

     

    Best Regards,

    Wearsky

  • yeagerman Profile Picture
    14 on at

    hi, do u mean this?

    yeagerman_0-1689152638013.png

     

  • v-xiaochen-msft Profile Picture
    on at

    Hi @yeagerman ,

     

    No...

    Can I ask what's the value of this parameter?

    vxiaochenmsft_0-1689153011236.png

    Let's say its value is 'value1', do you have an item with this value before updating?

    vxiaochenmsft_1-1689153287862.png

    vxiaochenmsft_2-1689153348958.png

     

    Best Regards,

    Wearsky

  • yeagerman Profile Picture
    14 on at

    yes i do have contents in my table

    yeagerman_0-1689157000109.png

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard