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
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