cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Raymondwkmok
Regular Visitor

Exporting File Path to Excel

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


Power Automate Issue 1.png

2 REPLIES 2
mahoneypat
Solution Sage
Solution Sage

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

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

Power Automate Issue 2.png

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (14,319)