Hello everyone, I need the community's help for some task I am trying to automate.
I am reposting this as I can't seem to find an answer to my issue.
I'm building a Power Automate flow that detects when a new project folder is created inside /Test-Flow-Implementation/ as a Root. If the folder contains a subfolder named 03_Report, the flow should create a text file called QA_Form_<ProjectName>.txt inside 03_Report. The filename should dynamically match the project folder name.
The flow consists of:
- Trigger – "When a file is created (properties only)" in
/Test-Flow-Implementation/, with subfolders included.
- Get File Metadata – Checks if
/Test-Flow-Implementation/<ProjectName>/03_Report exists.
- Condition – If the metadata request returns a valid ID (i.e.,
03_Report exists), proceed.
- Create File – If the condition is met, generate
QA_Form_<ProjectName>.txt inside /Test-QA-Implementation/<ProjectName>/03_Report, containing a Microsoft Forms link.
Right now, the flow isn't triggering or is failing at the condition step. The metadata check might be incorrect, and the file path expression may not be resolving correctly. I need help ensuring that the flow properly detects 03_Report and executes only when it exists.
Below you will find the entire flow
-- First screenshot is just the entire flow and what it does like I explained above
-- Next screenshot is the first action "When a file is created(properties only)" and then its settings.
-- Second action (Get file metadata using path) - no particular settings here
-- Next the condition (So if that "03_Report" exists within that Subfolder of Test-QA-Implementation then do something -- or he if it does NOT equal null)
-- IF TRUE then create file and within that file add a link to a Forms document that I also created and would like to put into the 03_Report folder.
-- IF FALSE do nothing
--IF all of this flow just runs successfully then create a final log file that just says that everything went fine.
This should explain what I am trying to do.
When I press test, it tells me to create a folder inside of Test-QA-Implementation, but when I do, nothing happens. It's as if I didnt set my folders correctly.
This is the first time I am using Power Automate and this is leading me to desperation. This is the first time I am using Power Automate and this is leading me to desperation.
