get file content using path

[Khan321]

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.

BR

Naji

[ekarim2020]

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.

[Khan321]

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

[ekarim2020]

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.

[Khan321]

@ekarim2020 thanks for help 🙂

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

[ekarim2020 · Accepted solution]

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.

 

[Khan321]

@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. 

[ekarim2020]

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.

 

[Khan321]

@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?

[ekarim2020]

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.

[Khan321]

@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?

[ekarim2020]

Hi @Khan321 ,

I'm not clear of what you are trying to do at this point. But here are some ideas you could use in conjunction with contains function.

The following action finds files that match your filename format (using a regular expression):

Køretøjsliste for \d{7} for dato \d{2}.\d{2}.\d{4} - \d{2}.\d{2}.\d{4}.xls

 

The Find Files in folder by path should find the following 11 files in stored in the root of the OneDrive folder:

Køretøjsliste for 4874349 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874351 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874352 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874353 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874354 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874355 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874356 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874357 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874358 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874359 for dato 31.10.2022 - 31.10.2022.xls
Køretøjsliste for 4874360 for dato 31.10.2022 - 31.10.2022.xls

We can then loop through each file, getting the file Name and File Content as the example below shows:

 

Hope this helps.

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

[Khan321]

@ekarim2020  thanks again.

I can't get it work. 

the dates changes with ever file so i will rather try to save the files with only "Køretøjsliste for 5335565".

So i don't have date in it. 

I will  make another  post her in the community and see if i can make a flow which saves this attachments without date.  

thank you for your help and you solved my initial issue

BR 

Naji