Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Multiple uploads to a single MS Forms question and get link for each file into email body

(0) ShareShare
ReportReport
Posted on by 34

Hello!

 

I've been trying to build a flow where by a user can upload multiple files to 3 different questions in a Group MS Form and get the URL's for each file and display these URL's in an email body.

 

I'm currently just working out how to get this to work for just a single question using Parse JSON and appending the output but I'm not having much luck. I can get the URL out of the Schema but struggling to append it correctly

 

Email body:

 

Q1

URL1

URL 2

URL 3 etc

 

Q2

URL1

URL 2

URL 3 etc

 

Q3

URL1

URL 2

URL 3 etc

 

Appreciate any help from the community

 

 

  • jamesfisher Profile Picture
    34 on at
    Re: Multiple uploads to a single MS Forms question and get link for each file into email body

    Thanks @David_MA - I'm looking to just get the URLs out of the Parse JSON to link to the location of where the file is located on the SP site. Each question can have multiple uploads and this is where I'm struggling to get them all. Hope that helps 👍

  • David_MA Profile Picture
    11,744 Super User 2025 Season 1 on at
    Re: Multiple uploads to a single MS Forms question and get link for each file into email body

    If you figured out the need to parse the JSON and everything, what do you need to append to the URL? The Parse JSON action returns the URL of the file. This is the output from a recent run of a flow doing what you are asking:

    [
     {
     "name": "****************.docx",
     "link": "https://**********.sharepoint.com/personal/svc-nam-msautomation_********_com/_layouts/15/Doc.aspx?sourcedoc=%7B722B6647-BA1F-44EA-96DB-392ABD82A0AD%7D&file=************.docx&action=default&mobileredirect=true",
     "id": "01NH6E2QCHMYVXEH525JCJNWZZFK6YFIFN",
     "type": null,
     "size": 51770,
     "referenceId": "01NH6E2QHQ764RTUDRUVDJMEVFHJDKD4DH",
     "driveId": "b!drnIoxWNuUGiA-1K4jUwXzmCBgdV_elPgN81i5KJw3stQA77BYNSTrTHAud1cbo3",
     "status": 1,
     "uploadSessionUrl": null
     }
    ]

    You can use a concat expression to add whatever you need to the end of the link value from the Parse JSON action in a Compose action. For example:

    concat(items('Apply_to_each_Attachment')['link'],'whatevertoappend')

    This would need to be within an Apply to each action, which maybe is what you are struggling with:

    David_MA_1-1688583086862.png

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1