@EuniceCoetzee Here is my suggestion. Remember to rename your actions to keep things organized!
Compose the Dynamic Content
Put the dynamic content of the Full Name (or whatever column of data you are trying to match to your file) into a Compose action.
Return File Count
For troubleshooting purposes—add a Compose action to output the number of files in your folder. Add an expression and use the length() function.
Insert the value output from the List Files in folder action.
Run a test.
Confirm the output of both Compose actions.
Filter Array
Instead of using an Apply to each and Condition action to check each file returned. It's more efficient to use a Filter Array action. To learn more about how to use the Filter Array action, please refer to this recent YT Tutorial I uploaded.
Insert the value from the List files in folder action into the From field. In the first value field, insert the Name or Display name dynamic content—they both return the same values.
I've changed the operator to contains. My file name syntax is Full Name Certificate.pdf. You will need to adjust the operator based on your scenario.
In your previous condition action you used the equal to operator. This means the content in the first value and second value must be an exact match.
In the second value field, insert the outputs from the Compose action storing your dynamic content.
Return Count of Filtered Items
Add a Compose action to store the count of items returned from the filter array action.
Run a test. If your condition is correct, the number of items returned should match the number of files you are expecting.
Follow the YT Tutorial from this section to return the dynamic content from the Filter Array action.
Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!
|
