Forum Discussion

BolaMSS's avatar
BolaMSS
Copper Contributor
Jan 23, 2020
Solved

Extract URL from file upload question in Flow from Microsoft form

I have an MS flow approval workflow for a form and I am using the new file upload feature. I'm trying to get the URL path to files to display correctly when sent in the email body using flow. 

 

At the moment inputting the dynamic expression for the file upload returns something like the below

 

[{"name":"file_name_uploader name.pdf","link":"https://mssoc-my.sharepoint.com/personal/bola_labulo_mssociety_org_uk/Documents/Apps/Microsoft%20Forms/MSS%20New%20Supplier%20Form/Question/I51703_131219_9_NGMCLON_Mediacom_Ann%20McDougal.pdf","id":"01SRUKHVHWF2EPTNWXGRFJG2OJLGWEP4U3","type":null,"size":53051,"referenceId":"01SRUKHVHVSSRUV4ZAEVC32ET433VDJFEI","driveId":"b!fIPurN8Gv0KRaCyuRrHjC9jY71Bph9dEih0_Lpx16CbadVWIm1v3SYdD_VMzYe5M","status":1,"uploadSessionUrl":null}]

 

Is there an Azure logic expression or another way to extract just the link to the file?

 

Thanks

  • BolaMSS  the blog post at https://www.bythedevs.com/post/working-with-files-on-ms-forms-in-ms-power-automate shows you how to parse the JSON and get the url.

     

    Rob
    Los Gallardos

    Microsoft Power Automate Community Super User

3 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    BolaMSS  the blog post at https://www.bythedevs.com/post/working-with-files-on-ms-forms-in-ms-power-automate shows you how to parse the JSON and get the url.

     

    Rob
    Los Gallardos

    Microsoft Power Automate Community Super User

    • lahirubandara's avatar
      lahirubandara
      Copper Contributor
      Hi,

      I did manage to get the URLs. But can you please help me to find the way to add those multiple URLs to a single column in SharePoint List??

Resources