Hi there, I've created a MS-Form for users to upload photos. Together with a workflow built for the Form, the file path will be exported to an Excel file.
However, the file path exported contain some other string before and after the actual file path, like the file name. Such that I cannot reach the photo when I clicked the file path at the Excel.
May I know what I can do to overcome this issue.
Thanks
Raymond
Dear Pat, thanks for the advice.
I've attempted to use the formula but encountered the problem below.
I've indeed replaced only the wording of 'vLink' with the Dynamic Content of the link.
Thanks
Raymond
You can use an expression like this to parse out the link from that string. I tested in with a variable called vLink, so replace those with your expression.
substring(variables('vLink'), add(indexOf(variables('vLink'), '"link":"'), 8), sub(indexOf(variables('vLink'), '","id"'), add(indexOf(variables('vLink'), '"link":"'), 8)))
Regards,
Pat