Add a row into a table is writing on every row in a column

(0) Share

Report

Posted on by CharlesBrewer

697

Hello,

So I have a form, and I want the data to write to an Online excel file. This is working just fine for every column except for one. As a part of the form they might upload files, so I have those going to a One Drive, and then a variable gets set to give me a URL to that folder on the One Drive :

And then for the "Add a row to a table" that variable gets written (as well as all the others):

The problem is on the Excel sheet, the "Uploads" gets copied to every row, for some reason :

Why would it do that? It's only doing that for the Uploads so I don't get it.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

BB-18031745-0 125 on at

Like (0)

Report
Copy link

Link copied!

Hi there,

It seems your issue is you are setting the "DownloadsArray" variable once and then reusing that variable for each row you create, that's why each row has the same value.

You will need some sort of loop to either set the "DownloadsArray" variable and then use it to create a collumn, or have the "DownloadsArray" variable be of type array, append the value for each item to the array, and then loop through that array when creating the rows.

Was this reply helpful? Yes No
CharlesBrewer 697 on at

Like (0)

Report
Copy link

Link copied!

@BB-18031745-0

Sorry I'm not sure what you mean. The variable (which is actually a String, not an array, ignore my name), gets set each time the flow runs, and uses the 'Entry Number' field which is a dynamic field. Then it 'Add a row into a table' only once, and the flow ends. I tried to run it through a Compose (Uploads Compose) but that didn't work either.

Was this reply helpful? Yes No
BB-18031745-0 125 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the extra info.

You mentioned the "Click for Uploads" hyperlink is always the same url for each item.
Have you checked the hyperlink in the "DownloadsArray" variable to see if it is giving the same url?

If the URL there is always the same, is it a problem with the "Entry Number" that the trigger is handing you?

If the URL in the "DownloadsArray" is correct, but the flow is setting the hyperlink to a different url, is there perhaps a problem with the excel script you're running?

Was this reply helpful? Yes No
Suggested answer

rzaneti 4,476 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @CharlesBrewer,

Assuming that you are not setting this value by accident in your Office Script, it looks like Excel is simply replicating the same value to all rows once you set the HYPERLINK formula to the newly added record. This is a default behavior from Excel.

If you have some flexibility to modify the table structure, you can maybe add an additional column to set up the link URL itself, and then reference it dynamically in your HYPERLINK formula, so the other columns wont be impacted by it. Something like this, for example:

If you want to go further and make even better, you can use the Office Script to copy and "paste values only" from HYPERLINK formula and then delete the additional column for storing the URL.

If the instructions are not clear enough or actually don't match your needs, let me know :)

For those who get to this thread in the future and are unfamiliar with Office Scripts, check this introductory article or this hands-on video about how to write data from Power Automate to Excel ranges out of tables.

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

If this is the answer to your question, please mark the post as Accepted Answer.
If this answer helps you in any way, please give it a like.

Check more Power Platform content on my website.
Lets connect on LinkedIn.

Was this reply helpful? Yes No
CharlesBrewer 697 on at

Like (0)

Report
Copy link

Link copied!

Sorry @rzaneti I really don't know what you mean. If the step is "Add a row into a table" I am just very confused to why it would be doing it for every row. I don't really want to add another column, no. I can understand if it was in a "For Each" but there isn't.

But that still doesn't want to work. This is a silly thing because it makes no sense to me, it's doing something I am not asking it to do and it's the only thing I need to fix to finish this.

Was this reply helpful? Yes No