cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Display hyperlinks to files submitted through forms in a specific column in a sharepoint list

I am using a Microsoft form as a guide for what photos to capture on an audit. I have multiple file upload questions corresponding to different areas of a machine. When I try to get the attachment into a SharePoint list, the power automation fails. The only way I can get it to run correctly is to set the  type in SharePoint to multiple line and to enable rich text.

 

If I do this the result i get in the column is JSON like this:

 

[{"name":"60A-0009.PDF","link":"https://xxxxxxxxxx.my.sharepoint.com/personal/xxxxxxxxxxx_com/Documents/Apps/Microsoft%20Forms/Purchase%20Request%20Form/Question/60A-0009%xxxxxxxxxxxxx.PDF","id":"01SIB53GUS5TG4ID5T3BDZ2OIG3EHY53IN","type":null,"size":104065,"referenceId":"01SIB53GRY5LS7FVGIBJHKJYQKX7VJQJX4","driveId":"b!-ddutP1x-EWsb992Za2JQQOmzx-Bf6tAhj3Xaze1ET6bydpP0puDQ7U48Ou6R1uk","status":1,"uploadSessionUrl":null}]

 

If i copy and paste the https: links from the code into my browser I get to the file, but I want to display the hyperlinks to the files that are clickable from the SharePoint list or display thumbnails of the files that I can click.

 

Any help would be much appreciated 

1 REPLY 1
Highlighted
Super User
Super User

Re: Display hyperlinks to files submitted through forms in a specific column in a sharepoint list

@dvather 

 

Do you want to update this URL-

link":"https://xxxxxxxxxx.my.sharepoint.com/personal/xxxxxxxxxxx_com/Documents/Apps/Microsoft%20Forms/Purchase%20Request%20Form/Question/60A-0009%xxxxxxxxxxxxx.PDF"

 

Pls let me know and also share your flow screen.

 

Thanks

Hardesh

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Users online (6,482)