Share
ReportI have ran the following flow, it shows as succeeded, but I dont receive the mails.
Flow - get file
Can someone please assist?
You’re offline. This is a read only version of the page.
11
I have ran the following flow, it shows as succeeded, but I dont receive the mails.
Flow - get file
Can someone please assist?
@EuniceCoetzee Here is my suggestion. Remember to rename your actions to keep things organized!
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.
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.
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.
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! |
You have to know cause of that, not me. See what has been returned by "List files in folder".
So, all 20 expressions show false, and the conditions are not satisfied. 😞
Do you perhaps know the cause of that - my files are saved in One Drive for Business?
Well, the flow runs as it should. But you have to check all 20 iterations 😉
One of the items:
Open an item in the history and check what happened.
Good morning,
I appreciate your prompt response.
My goal is to distribute certificates to various attendees. These certificates have already been renamed based on the full names and surnames listed in my Excel document. The condition for sending these certificates is to match the display name with the entries in the "Full Name" and "Surname" columns. Further details are outlined below. Please feel free to request any additional information you may require.
Thanks again!!
@EuniceCoetzee It looks like the condition in your Apply to Each action is returning false. I'm assuming your Send an Email action is in the YES branch of your condition which is why you aren't receiving any emails.
Can you show your full flow? What does your condition look like?
#1
WarrenBelz
146,679
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
All responses (
Answers (
