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 / How to Extract URL and...
Power Automate
Answered

How to Extract URL and add hyperlink from file uploaded in Microsoft form into Excel online

(0) ShareShare
ReportReport
Posted on by 181

hi all, i have a simple form that have 4 question, that 3 questions need upload file (question 2 is Mandatory)

I try to create the flow to save the ms form data to excel online.

AT_AlanTse123_0-1694048522130.png

 

AT_AlanTse123_1-1694013579938.png

 

It is successful to save but the result of questions 2,3,4 is like JSON format.

 
below is my flow:
AT_AlanTse123_2-1694013667703.png

 

AT_AlanTse123_4-1694013769906.pngAT_AlanTse123_5-1694013787700.pngAT_AlanTse123_6-1694013816041.png

 

May i know how to extract Json link data  and update the power automate to add hyperlink in excel?

Thank you very much for your help

 

Categories:
I have the same question (0)
  • AT_AlanTse123 Profile Picture
    181 on at

    Could anyone help me?

  • v-hanytian-msft Profile Picture
    Microsoft Employee on at

    Hi @AT_AlanTse123 ,

     

    You can Use "Select" Action to Get LInk.

    Replace this Action to Select. 

    vhanytianmsft_2-1694050829392.png

     

    vhanytianmsft_0-1694050720475.png

     

    vhanytianmsft_1-1694050769334.png


    Hope this will help you,

    Best Regards,
    Tina

  • AT_AlanTse123 Profile Picture
    181 on at

    Morning Tina, thank you for your reply, i update the flow as below, it is work if all question upload files.

    Also, may i know how to update the flow If no file upload as my Q2 and Q3 is not mandatory and add which content on the file 1 upload, file 2 upload and file 3 upload

    AT_AlanTse123_2-1694052177717.png

    AT_AlanTse123_3-1694052207792.png

     

     

     

    Thank you very much for your help.

  • v-hanytian-msft Profile Picture
    Microsoft Employee on at

    Hi @AT_AlanTse123 ,

     

    Please try this:

    vhanytianmsft_0-1694052761971.png


    Hope this will help you,

    Best Regards,
    Tina

     

  • AT_AlanTse123 Profile Picture
    181 on at

    Thank you Tina, it is work for Q1 , Q2 and Q3 all upload.

    But it will cause error if Q2 or Q3 not upload file.

    May i know how to fix it?

     

    Thank you very much.

  • v-hanytian-msft Profile Picture
    Microsoft Employee on at

    Hi @AT_AlanTse123 ,

     

    As I Know, if Q2 or Q3 not upload file, Condition will show error Message to tell you it Get No Content.

    However, the Flow will still run as expected.


    Best Regards,
    Tina 

  • AT_AlanTse123 Profile Picture
    181 on at

    Hi Tina,

     

    I had tried, it is not work that cannot update the excel file and show below error 

    AT_AlanTse123_0-1694054317014.png

     

    error detail:

    The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON_4')' is of type 'Null'. The result must be a valid array.

     

    May i know how to fix?

     

    Thank you

     

    AT_AlanTse123_1-1694054414177.png

     

  • Verified answer
    v-hanytian-msft Profile Picture
    Microsoft Employee on at

    Hi @AT_AlanTse123 ,

     

    We made a new sample for you.

    OverView:

    vhanytianmsft_2-1694058546413.png

    vhanytianmsft_3-1694058631603.png

    empty(...)

    vhanytianmsft_4-1694058746609.png

    vhanytianmsft_5-1694058862289.png

     


    Hope this will help you,

    Best Regards,
    Tina

     

     

     

     

     

     

  • AT_AlanTse123 Profile Picture
    181 on at

    Hi, Tina.

    Thank you very much for your sample.

    It works perfectly!!!!!!

    You are Genius!!!!

    Thank you very much for your help.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard