check if file exists in SharePoint Library

(0) Share

Report

Posted on by marial16

443

Hallo,

I have a recurrent flow that runs every day and reads 3 excel files uploaded in SP Doc Library.

I initialize the file names in 3 variables as they are fixed.

Then i use the Get tables excel connector.

However if the file name is not found, the flow fails.

I use 3 parallel actions for Get Tables in order to get all 3 files.

How can i make sure if there is any of the 3 files missing and prevent flow from failing?

In the get tables *File i am building the Name of file:

concat('/subFolder/File Name PROMO ',variables('var_DATE'),'.XLSX')

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Rhiassuring 8,690 Moderator on at

Like (0)

Report

Hi there,

You could use a "If fails" action. For example, even just a Compose (or an Email to notify you).

Right after your Get Tables action (the one that will fail), add in a Parallel Branch, then on one side add all of your normal actions - but on the other side, add Compose or Email, then, in that action, click on the ellipses, configure run after, and change the checkbox to "has failed". You will see the parallel action will turn to a red dashed line on one side.

Here's a screenshot - ignore my random stuff on the left. Just showing the "successful" branch:

The flow still has a fail in it so it does show it as an error, but it's a controlled error - something you're acting on.

OR - is the preference to determine which of the 3 files is missing FIRST, and then notify you (maybe an approval task for update?) to fix it before it runs?

Cheers,

Rhia

Was this reply helpful? Yes No
Verified answer

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (3)

Report

Hi @marial16 ,

in order to handle everything inside your flow and reacting to a non existing file, you can also use the connector „Get Files (properties only)“ and check the length of the answer like already mentioned here: https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-check-if-a-file-exists-in-a-SharePoint-library-by-file/td-p/338207

As the answer is already three years old, I double checked it today and it still valid:

Note: Make sure to use the length of the value and not the body:

length(outputs('Get_files_(properties_only)')?['body/value'])

1 people found this reply helpful.

Was this reply helpful? Yes No
Jv_Roccon 9 on at

Like (0)

Report

Hi GeorgiosG,

I tried it in my case, but even when the file is founded the value is blank. Do you know how can I repair it?

Was this reply helpful? Yes No
Stinow 13 on at

Like (0)

Report

The array called 'value'? Maybe you can check the trigger; often if it starts after a file is uploaded, the file can still be uploading and you'd need a Delay action.

Could you elaborate what you mean with value is blank?

Was this reply helpful? Yes No