Solved: Update a Row in File with a changing name

Skybluekid · ‎09-21-2023

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.

rzaneti · ‎09-26-2023

Hi @Skybluekid ,

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

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):

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:

The flow runs successfully:

And this is the output:

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:

Output:

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/

View solution in original post

rzaneti · ‎09-21-2023

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).

Skybluekid · ‎09-21-2023

Hi @rzaneti

This is what I got:

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

rzaneti · ‎09-21-2023

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 · ‎09-26-2023

Hi @rzaneti

Please see below

rzaneti · ‎09-26-2023

Hi @Skybluekid ,

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

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):

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:

The flow runs successfully:

And this is the output:

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:

Output:

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/