web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Can't use a VAR to mak...

Power Automate

Answered

Can't use a VAR to make a path

(0) Share

Report

Report

Posted on by SP-04030758-0

14

Hello,

I'm trying to use a VAR to make a dynamic path, but when i try, PowerAutomate returns me that :

When I look in the debug console, the VAR value looks ok, but PowerAutomate tells me there's a problem ("The action "Get file content" has failed...").

Do you have any solution ?

Thanks a lot !

Categories:

Power Automate Desktop

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,891 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
tHi @SP-04030758-0,

The File Identifier requires encoded values. For example the '/' needs to be %2F.

You can use the encodeUriComponent function for this. Btw, you can also use the yyyy-MM-dd format directly in a utcNow function (assuming you are using that within your formatdatetime function.)

Below is an example (make sure you swap the Test-NE- part by whatever you have in your setup. It is not visible in your screenshot).

encodeUriComponent(concat('/Shared Documents/DATA/Test-NE-', utcNow('yyyy-MM-dd'), '.csv'))

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
SP-04030758-0 14 on at

Like
a
(0)

Report
Copy link

Link copied!

@Expiscornovus , thank you for your answer !

I've find a trick to do this job, but your solution seems better.

Thank you !

Was this reply helpful? Yes No

Join the conversation