Reminder Emails By Date

[koray1]

Hello,

The following flow does not give an error. But I can't receive mail. Where is wrong?

-----------

I think the problem related with dynamic content.

If I add dynamic content to the mail in Flow, sending mail does not work. If I don't add it, it sends mail. How can I solve this problem?

With dynamic content added / doesn't work

With no dynamic content added / work properly

[StretchFredrik]

Your email loop is empty  which is why its not sending any emails.

Most likely it is not finding the item in the "Return 3 and 7 days"

[koray1]

Hi @StretchFredrik 

Actually, I have the appropriate date for the results, but I can't receive mail 😞

[StretchFredrik]

Can you show me the output from the step?

[StretchFredrik]

Maybe the issue is that in sharepoint its 3.12. and in the flow ur checking for 03.12

[koray1]

Sure @StretchFredrik 

is it enough for output.

[StretchFredrik]

I need a screenshot of this:

Also, check my previous comment about the dateformats 🙂 

[koray1]

Hi @StretchFredrik 

Output is as below.

{"statusCode":200,"headers":{"Transfer-Encoding":"chunked","Vary":"Origin,Accept-Encoding","X-NetworkStatistics":"0,525568,0,0,53,0,23726","X-SharePointHealthScore":"0","X-MS-SPConnector":"1","X-SP-SERVERSTATE":"ReadOnly=0","DATASERVICEVERSION":"3.0","SPClientServiceRequestDuration":"65","X-DataBoundary":"EU","X-1DSCollectorUrl":"https://eu-mobile.events.data.microsoft.com/OneCollector/1.0/","X-AriaCollectorURL":"https://eu-mobile.events.data.microsoft.com/Collector/3.0","SPRequestGuid":"61bf6956-1474-4b55-9920-7412860ed61d","request-id":"61bf6956-1474-4b55-9920-7412860ed61d","MS-CV":"Vmm/YXQUVUuZIHQShg7WHQ.0","Strict-Transport-Security":"max-age=31536000","X-FRAME-OPTIONS":"SAMEORIGIN","Content-Security-Policy":"frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com securebroker.sharepointonline.com;","MicrosoftSharePointTeamServices":"16.0.0.23109","X-Content-Type-Options":"nosniff","X-MS-InvokeApp":"1; RequireReadOnly","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","x-ms-apihub-obo":"false","Cache-Control":"max-age=0, private","Date":"Wed, 30 Nov 2022 12:09:12 GMT","P3P":"CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"","X-AspNet-Version":"4.0.30319","X-Powered-By":"ASP.NET","Content-Type":"application/json; charset=utf-8","Expires":"Tue, 15 Nov 2022 12:09:13 GMT","Last-Modified":"Wed, 30 Nov 2022 12:09:13 GMT","Content-Length":"12"},"body":{"value":[]}}

Yes, sharepoint date is coming as 3.12.2022. How can i change format as 03.12.2022 ?

[StretchFredrik]

The body is empty because your ODATA filter is not getting any hits because the data in SharePoint says 3.12.2022 and the filter says 03.12.2022, they need to be identical.

[koray1]

@StretchFredrik 

How can i solve this? I'm not very experienced in this. I changed my expression as addDays(utcNow(),7,'d.MM.yyyy')
but it doesn't work again.

[StretchFredrik]

change it to 'dd.MM.yyyy'

[koray1]

It was already 'dd.MM.yyyy'. As I wrote in my first post 😞

[koray1]

Hi @StretchFredrik 

I think I found the problem. 

If I add dynamic content to the mail in Flow, sending mail does not work. If I don't add it, it sends mail. How can I solve this problem?

With dynamic content added / doesn't work

With no dynamic content added / work properly

[koray1]

Tagging some people, who might help.

@Pstork1 

@grantjenkins 

@v-liwei-msft 

@v-yujincui-msft 

@v-jefferni 

@v-chengfen-msft