Power Platform Community Forum Thread Details

Hello,

Currently we have an intake process, trigged from a Form. We need the data from that Form to translate into a working Excel sheet. My flow to translate the data seems to be working great, except for the file upload.

It appears to be sticking the whole object into the cell, where I just need the link data. I'm not overly familiar with how to "trim" what it's pulling - the "link":" " section is correct, i need to slice that out somehow.

Any ideas would be much appreciated.

Sample content from what it pulls, by referencing the dynamic "File Upload" question.

[{"name":"document 1.docx","link":"https://foo.sharepoint.com/sites/bar/_layouts/15/Doc.aspx?sourcedoc=%7B2E6-F004-4F92-AF88-054BF06EC91B%7D&file=document 1.docx&action=default&mobileredirect=true","id":"01WFUVV2HGIQSJH27CAFI3","type":null,"size":848,"referenceId":"012H3E55Q7FFRONBY6AVA2DCJ","driveId":"b!QdKvt0AqAz5UsY4TKH45n5x6ft9MkBlyZswlLar6T6Nwlp_h","status":1,"uploadSessionUrl":null}]

EDIT:
Found a potential solution that works for now, not sure if this is best practice or if it'll break soon. Added a Parse JSON step for the upload, then linked the cell to the parse-json: "link" field.

Categories:

Building flows