Skip to main content

Notifications

Power Automate - Building Flows
Answered

Update a Row in File with a changing name

(0) ShareShare
ReportReport
Posted on by 252

Hi All,

 

I have a excel template which is stored on Sharepoint.  In tthe template I have a table which I would like to update.  During the course  of my flow, the template gets renamed and saved into a folder.  Later in the flow, I would like to update that table in the renamed file.  I have tried to use Update a Row and in the File box, I used dynamic content to get to the specific file.  In the Table box, I used Custom value for the name of the table to update and the same for the Key Column.  

 

When I run the flow, the connector could not find the columns.  

 

Any ideas would be appreciated.

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Update a Row in File with a changing name

    Thank you very much @rzaneti 

  • Verified answer
    rzaneti Profile Picture
    rzaneti 3,427 on at
    Re: Update a Row in File with a changing name

    Hi @Skybluekid ,

     

    You are entering the 'properties' incorrectly. Let's take this range as example:

    rzaneti_0-1695728287680.png

     

    In our flow, we will first convert this range to a table, which will contains a header (col1, col2, col3 and col4) and a single record (entry1, entry2, null, entry4):

    rzaneti_1-1695728312666.png

     

    Now let's update this record, to change it's value from col2. To achieve it, we need to pass an object as 'properties' input, where the key will be the name of the column that we want to update (col2, in our case) and the value will be the new data to be assigned (entry456789, in our case), as highlighted below: 

    rzaneti_2-1695728431458.png

     

    The flow runs successfully:

    rzaneti_3-1695728513214.png

     

    And this is the output:

    rzaneti_4-1695728530259.png

     

    Now let's do the same thing, but with changes for both col2 and col3. I've removed the table format from the range (as the table will be created dynamically) and set 'col2' to 'entry2' again:

    rzaneti_5-1695728632078.png

     

    Output:

    rzaneti_6-1695728644285.png

     

    Also, I'm sharing here some articles about some strategies to work with Power Automate and Excel (they must be basic for you, but it can help any other starter user that reads this post):

    - Integrating Excel Tables and Power Automate: http://digitalmill.net/2023/07/17/integrating-power-automate-and-excel-tables/ 

    - Reading data from Excel tables: http://digitalmill.net/2023/07/19/reading-data-from-excel-tables-in-power-automate/ 

    - Inserting/updating data in Excel tables: http://digitalmill.net/2023/07/24/inserting-and-updating-data-into-excel-tables-with-power-automate/ 

    - Working with Excel ranges: http://digitalmill.net/2023/09/01/accessing-excel-ranges-with-power-automate/ 

     

    Let me know if it works for you or if you need any additional help!

     

    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Solved.
    If this answer helps you in any way, please give it a like.

    http://digitalmill.net/ 

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Update a Row in File with a changing name

    Hi @rzaneti 

     

    Please see below

    Skybluekid_0-1695727741641.png

     

  • rzaneti Profile Picture
    rzaneti 3,427 on at
    Re: Update a Row in File with a changing name

    Hi @Skybluekid ,

     

    Just to confirm: you cleared the values from the shared output before sharing it, right? I'm asking it because, if you didn't, the fact that the table contains only blank values could be a problem for an 'Update row' action 🙂

     

    I also see that you have extra blank spaces on the left side of some column names (Number, Name, Date, Out and Comments). If you didn't include these extra blanks in you 'Update row' action, make sure to use the exact same name from the outputs. 

     

    If you already did it, please share an image of your 'Update row' action in edit mode, so we can see how did you arrange the inputs.

     

    Let me know if it works for you or if you need any additional help!

     

    -------------------------------------------------------------------------
    If this is the answer for your question, please mark the post as Solved.
    If this answer helps you in any way, please give it a like.

    http://digitalmill.net/ 

     

  • Skybluekid Profile Picture
    Skybluekid 252 on at
    Re: Update a Row in File with a changing name

    Hi @rzaneti 

     

    This is what I got:

    Skybluekid_0-1695300161785.png

    I would need to update the four sections, Name, Date Out and Comments.

  • rzaneti Profile Picture
    rzaneti 3,427 on at
    Re: Update a Row in File with a changing name

    Hi @Skybluekid ,

     

    Could you please include in your flow a 'List rows present in a table' action, to access the table in the created file? It is just for test purposes and you will provide the same inputs that you did to the 'Update row' action, except for the column key/values. 

     

    After that, please share an image of your 'List rows present in a table' outputs (removing any sensitive content) or the error message (if any). 

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