You’re offline. This is a read only version of the page.
I used Microsoft Flow's template "Send a Happy Birthday email to employees on their birthday" and whenever I would test the run, it would say "Flow Failed". I received help regarding this issue yesterday in Community Forums and now the flow says "Successful". However, the flow is supposed to send an email and it does not. It's been 24 hours. Why isn't the email being sent? Or if it is being sent, why am I not receiving it?
Here is a picture of my flow:
And here my condition in advanced mode:
@equals(equals(items('Apply_to_each')?['Birthday_x0020_Date'], formatDateTime(utcNow(), 'MM-dd')), true)
...and basic mode:
Isn't that what we discussed in post #24 or did I not do something correctly? I changed my condition to the format you requested. It didn't return false, it just failed.
And I attempted to recreate every template I have, they all didn't work. I don't know what you mean out-of-the-box template. I have one with the two Compose actions, I have the one that filtered out today's date in Get Items, and I have the one that is basically Flow's template with slight formula changes. Which one - or other - are you referring to?
Hi @Anonymous
Just before I step out the door. Please can I refer you to post 23 again that I posted.
I mention this being the expression for "Compose"
Share
Report
All responses (
Answers (
formatDateTime(items('Apply_to_each')?['BirthDate'], 'MM-dd')
Please check it as I notice earlier in the thread another had you set the compose to
items('Apply_to_each')?['BirthDate']
This was when your list was in MM-dd format. Now that it's not ... this may be why you are returning false. This is also why I asked you to use the out of the box template as it has the expressions (formula) as I have mentioned in post 23.
Thanks, Alan
As I mentioned earlier, I recreated every template that I had. The one with the filter, the one with the compose, and the one that is just Microsoft's basic template. None of them worked.
Hi @Anonymous
I would go back to using the out the box template that has no compose actions in it.
That's kind of what I would have hoped you would have done as I menttioned the new flow & new list. The new Flow using the template out of the box doesn't have compose actions in it.
Unfortunately, I have run out of time for tonight (UK), but as I posted a few posts back, the new list, with correct date type column has worked for me.
Thanks, Alan
The only thing that was in Compose was Dynamic Content: Birthday Date. I just entered in your formula and the flow failed.
Original Compose:
New Compose:
Hi @Anonymous
Is this what's in both your Compose actions, "Compose" & "Compose 2"?
Compose
items('Apply_to_each')?['Birthday_x0020_Date']
Compose 2
formatDateTime(utcNow(), 'MM-dd')
If so, Change "Compose" to this so we have matching formats. Otherwise, I advise using the out the box template that has no composes in it. Compose 2 can staty the same assuming theyre in the order I think they are.
formatDateTime(items('Apply_to_each')?['BirthDate'], 'MM-dd')
Thanks, Alan
#1 and #2: SharePoint list has a Birthday Date column that uses date type and there is a birthday for today in there.
Both entries return False.
Get Items, Body: (I changed any company information to "----"
Hi @Anonymous
It's strange this isn't pulling through for you as it is for me. Sorry for the issues you are having.
Can I check a few things ... just to be sure.
1) the column in SharePoint is using date type
2) There is a matching Birthday of today in there
3) Both of the 2 entries in your list return false?
4) Can I see the expanded output from "Get Items". You can copy and paste the JSON output and paste it in.
My JSON is like (for reference):
{
"@odata.etag": "\"1\"",
"ItemInternalId": "1",
"ID": 1,
"Title": "Person",
"PersonName": "Jane",
"Email": "Jane@domain.co.uk",
"BirthDate": "2013-02-25",
"Modified": "2019-02-22T10:21:54Z",
"Created": "2019-02-22T10:21:54Z",
"Author": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
"Claims": "i:0#.f|membership|jane@domain.co.uk",
"DisplayName": "Jane",
"Email": "jane@domain.co.uk",
"Picture": "https://tenat.sharepoint.com/sites/AlansContent/_layouts/15/UserPhoto.aspx?Size=L&AccountName=jane@domain.co.uk",
"Department": null,
"JobTitle": null
}
Thanks, Alan
I also tried to recreate with the Filter flow. It finally said Ran Successfully, however the email is grayed out and I still haven't received an email.
I just created a new List and Flow, it's still returning False.
#1
WarrenBelz
146,618
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,948
Most Valuable Professional
