I have a manually triggered (button) Power Automate flow set up in a SharePoint Document library.
When the flow is triggered, the user is prompted to attach a file in the run flow window (this new file will replace/override the selected file).
The first step of the flow is to do a check to make sure the new uploaded file does not already exist in the library.
I am using ‘Get files (properties only)’ with a Filter Query:
I am then using a ‘Condition’ step to confirm if a file was found of this name or not.
Expression being used as follows:
length(outputs('Get_files_(properties_only)_2')?['body/value'])
If a file of the same name and extension exists, an email notification is sent to the user who triggered the flow and the flow is terminated (cancelled).
This has been working fine (I have an example flow from 2 days ago that worked).
Today I have a scenario where a file of the same name and extension existed but it was not picked up by this condition / check and caused an issue further down in the approval flow.
I am trying to diagnose why the ‘Get files (properties only)’ did not return a value for the file that existed.
Below is a screenshot of the outputs and another showing that the file exists and can easily be found with a search.
Any ideas why the file was not picked up in this instance?
