get file content using path

(0) Share

Report

Posted on by Khan321

231

Hi EveryOne 🙂

I have a flow where i get "Get file content using path" where i get files from oneDrive using "Policy Nr" it worked fine using the files below:

But now i have been told that files are going to be saved with different names where the "Policy Nr" will be included.

The files looks like this:

My question is, is that possible to get the correct file using only "Policy Nr" even though it is only some part of the file name, not complete name?

and the dates in the file name changes all the time 🙂

Thanks for help in Advance 🙂

let me know if i you need more inof.

Naji

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Khan321 ,

If I understood correctly, you could use the contains() function to check whether the filename contains the Policy NR. For example:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Khan321 231 on at

Like (0)

Report

Hi @ekarim2020 🙂

Yes you understood correct.
I tried to do as you said but it gives an error.

This is how i used in flow:
Is this correct way to do it?

I get thing error.

BR
Naji

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

The 404 error means that the file could not be found.

In your path I see:

/Skrivebord/Power Automate/Excel filer/4874349

You need to add the file extension to the Compose 2 action:

/Skrivebord/Power Automate/Excel filer/4874349.xls

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Khan321 231 on at

Like (0)

Report

@ekarim2020 thanks for help 🙂

the flow runs but it makes the condition false. it does not find the file after adding .xls.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Khan321 ,

Please check the document path and file extension.

Here is a working demo:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Khan321 231 on at

Like (0)

Report

@ekarim2020 🙂

I think the path is correct. Let me send you complete flow with path.

Her are the files located:
english:
Danish

error:

Thanks for your help.

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

The document path should point to OneDrive in the cloud and not to your OneDrive files stored on your local computer:

Note the forward slashes in the path above.

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Khan321 231 on at

Like (0)

Report

@ekarim2020
same issue 🙂
A stupid question:
when we initial variable, we assign type "string" but the PoliceNr is "numbers"
PoliceNr in excel file:

and in condition we tells it if string has number.

could it be an issue?

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (1)

Report

Just to confirm, is

If the PolicyNR was being read as an integer value you would get an error, for example:

If the Get file content using path is still not working, check and correct the path.

Select the file manually in order to check the actual file path:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Khan321 231 on at

Like (0)

Report

@ekarim2020 it works now but only for 1 file after choosing the direct path in the get file content.

It only get the file content of the file which Policy Nr i gave in "Initialze variable".
How can i make police Nr dynamics so takes all the file with the PoliceNr?

Was this reply helpful? Yes No