Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Exporting File Path to Excel

(0) ShareShare
ReportReport
Posted on by 36

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

  • RM-06090351-0 Profile Picture
    RM-06090351-0 36 on at
    Re: Exporting File Path to Excel

    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

  • mahoneypat Profile Picture
    mahoneypat 1,720 on at
    Re: Exporting File Path to Excel

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard