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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Creating a specific fl...
Power Automate
Suggested Answer

Creating a specific flow that won't override my attachment links on excel

(1) ShareShare
ReportReport
Posted on by 23
I have made a Microsoft form and it is all working fine populating into the exact excel spreadsheet I need it to. Now I want to add an attachment question to the form but in the past I have had problems with making each attachment populate as a link and also the most recent attachment link overrides the previous attachment links submissions, turning all the attachments into the same link. I am looking for help on creating a flow that not only pulls the attachments and turns them into links in the spreadsheet but also make sure that every submission has its own unique attachment link. Could anyone please help me create a flow to represent that? 

This is my current flow and it is working fine:



Thank you in advance!!
I have the same question (0)
  • Suggested answer
    Haque Profile Picture
    3,653 on at
     
    You are almost there, let's revisit the steps and extrapolate what got missed out:
     
    1. Trigger: "When a new response is submitted" for Microsoft Form - you did it right.
    2. Action: "Get response details" - you did it right for retrieving form data, of course including attachments.
    3. Parse Attachments: The attachment question returns an array of file info (name, link) I guess. Use an "Apply to each" loop to process each attachment individually-this is what you missed out.
    4. Copy Attachments to a SharePoint or OneDrive folder - this is important because to create link of a file it must exist first somewhere.
     
    This is two steps task: 
     
    a. Please use either action "Get file content using path" or "Get file content" - you will be able to fetch the attachment content.
    b. Please use "Create file" action in a SharePoint document library or in OneDrive folder to store the attachment. Doing this you are making sure  there is a stable, unique URL for each file.
     
    5. I am sure you are still inside the "Apply to each" loop - and here, at this point, append each file's url to a variable (string of course) or even array variable - doing so you are separating links by commas or line breaks (whatever you want). 
     
    6. We have exited the loop and we having a comma/line break separated url - now we can update the excel file. At this point let's update the Excel row corresponding to the form submission with the concatenated attachment links string. You can assist an Excel row to be unique (can use response Id or timestamp) to mark and find the correct excel row.
    7. Now you sen the email, "Send an email notification V3"
     
    Note: We need to avoid overwriting links - to dos so, we need to make each submission creates a brand new row in excel plus we can store all attachments links for that particular submission in once cell, separated clearly(by comma/line break), and finally for any new submissions let's not update existing rows.
     
    Please let me know if this helps.
    Thanks.
     
     
     
  • André Arnaud de Calavon Profile Picture
    679 on at
    Hi,

    Can you explain in detail what you want to achieve? Should a user upload a file in a Form or provide a link? Does the Excel file contains multiple rows with multiple links that needs to be attached as files to the email? Can you probably enrich your question with examples?
  • LS-17022154-0 Profile Picture
    23 on at
    Hi @André Arnaud de Calavon,

    So I made a project Intake form where we ask for basic information like project details, requirements, description, etc. 

    The last question is a supporting document question. So I want a flow that will populate that attachment as a clickable link into that same excel spreadsheet and make sure each submission has their own unique link instead of getting overriden by the most recent submission. 

    I have had success turning the attachments into links that populate into the table I created but can't find a solution for making sure they each are unique in regards to their submission. 

    @Haque

    Thank you so much for that, I am trying to do what you said but I am struggling a bit understanding exactly the steps required and what needs to be done. I am not the most tech savvy person, so I might need you to be a little more clear and simple on the steps required to fix my flow. 

    Thank you so much!!
  • André Arnaud de Calavon Profile Picture
    679 on at
    Hi,
     
    I'm not sure if I understand the requirement. Do you need a kind of duplicate check before adding the new row in Excel?
     
    If so, you can List the rows, append a filter on the attachment link and check if it is already in use.
    If not, can you provide some examples?
  • LS-17022154-0 Profile Picture
    23 on at
    @André Arnaud de Calavon

    So the problem I have been having is anytime a submission comes in, the attached document will override ALL of the previous submission attachments. So if row N is the row that populates the attachments submitted with the form. The most recent attachment will override all other attachments in row N. 

    So my ask is finding a flow that will not only populate the attachments as a simple link we can click on, but also make sure every time a submission populates on our excel that every submission has their own unique attachment.
  • André Arnaud de Calavon Profile Picture
    679 on at
    Can you please provide examples of the current behavior, e.g. share some screenshots?
  • LS-17022154-0 Profile Picture
    23 on at
  • Haque Profile Picture
    3,653 on at
     
    As you progress with the flow (if you follow the steps I mentioned), please do let me know exactly where you get stuck or feel discomfort.
     
  • André Arnaud de Calavon Profile Picture
    679 on at
    Can you share what exactly you have as values in your Add a row into a table action? Do you only have one iteration or is it part of a loop?
    Is the Excel sheet having a formula in this column or hard values?
  • trice602 Profile Picture
    16,298 Super User 2026 Season 1 on at
    Hi there!
     
    Following up on our discussion from LinkedIn msgs.  Yes, please share your screenshots of the Add a row, I can't provide any help without seeing the work.  Many thanks!  
     
     

    ------------------------------------------------

     

     

    ⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard