Power Automate overriding links on excel

(0) Share

Report

Posted on by LS-17022154-0

I created a Microsoft Form owned by our team that sends all submitted data into an Excel file stored in our Teams channel, and everything is working correctly except for the file attachments. The attachments either come into Excel without showing as clickable links, or when they do come in as links, the newest submission’s attachment link overwrites all the previous ones, so every row ends up showing the same link. I need help building a Power Automate flow that will correctly store each file attachment, create a unique clickable link for every submission, and make sure each row in Excel keeps its own individual attachment link without being replaced by the most recent submissions.

Here is what I have so far:

Thank you in advance!!!

Categories:

Building flows

Using flows

General topics

I have the same question (0)

All responses (8)

Answers (0)

Sort by

wyattdave 493 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LS-17022154-0,

would it be possible to show a screenshot of the Excel action you are using. If you are using a add row to table it shouldn't be editing your current row, but adding a new row below. Or is this because there are multiple attachments, if there are multiple attachments you need to loop over the attachment array and add a row per attachment.

Was this reply helpful? Yes No
LS-17022154-0 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @wyattdave

I am using Add a row to table. That is what I've been hearing but it still is overwriting the previous attachments with the most recent one.

Was this reply helpful? Yes No
wyattdave 493 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you send screenshot with the excel action open

Was this reply helpful? Yes No
LS-17022154-0 23 on at

Like
a
(0)

Report
Copy link

Link copied!

@wyattdave The picture above is all I have. I deleted the previous flow because it wasn't working. If you could just guide me on how to create a flow that will accomplish what I'm looking for, that would be awesome!!

Was this reply helpful? Yes No
Suggested answer

wyattdave 493 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

If you add the add row to a table, set the file and table. Then set inputs to relevant columns it should work. Let me make a flow and send screenshot

Was this reply helpful? Yes No
LS-17022154-0 23 on at

Like
a
(0)

Report
Copy link

Link copied!

@wyattdave I understand it SHOULD work, but it doesn't. The attachments would just come in like a bunch of confusing letters. I need for the flow to make them into clickable links and make sure they don't override each other.

Was this reply helpful? Yes No
wyattdave 493 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Should look like this

Was this reply helpful? Yes No
LS-17022154-0 23 on at

Like
a
(0)

Report
Copy link

Link copied!

@wyattdave

Yes, it looks just like that. I think you are missing my problem. Everything is populating on the excel fine except the attachments. I one have to figure out a way to turn each attachment into a clickable link and then the second problem is the most recent attachment is overriding all previous ones.

Was this reply helpful? Yes No