Hello,
I am working on an automated email system for my team that involves a calendar of tasks created in Excel. I am attempting to filter the table based on the date of the task or tasks and sending a daily recurring email to my team that indicates these. Unfortunately, when the flow processes, it does not send a single table of tasks and instead sends an email for each entry that says "No Task Today." I am wondering where the logic is going wrong. I have my Excel Table ("DPT") and MS Flow screenshots attached.
DPT Excel Table
DPT Automation Flow
Solved! Go to Solution.
Hi @aselestok2 ,
Please try to configure Flow by referring to the following method.
There are two issues that need to be addressed here:
Please check this similar thread and see if it helps:
Expression reference:
addDays('1899-12-30',int(item()['Date']),'yyyy-MM-dd')
Here you need to use variables to store what needs to be displayed in the Html table, and then use it to create an HTML table.
Image reference:
Details in Apply to each:
Please take a try.
Best Regards,
I believe your issue stems from the fact that Excel stores date values differently than Flow expects. As a result, your condition will never be true.
There are a number of ways to approach this issue, but here is is a link to a solution with one method that I have used in the past.
Here is a link to a post that shows another way of approaching the issue.
Also, you may want to remove the "Apply to each 2" loop - it does not appear as though it is serving any purpose.
Hi @aselestok2 ,
Please try to configure Flow by referring to the following method.
There are two issues that need to be addressed here:
Please check this similar thread and see if it helps:
Expression reference:
addDays('1899-12-30',int(item()['Date']),'yyyy-MM-dd')
Here you need to use variables to store what needs to be displayed in the Html table, and then use it to create an HTML table.
Image reference:
Details in Apply to each:
Please take a try.
Best Regards,
Hi,
I have similar application, where I'm not getting the date column for formatting. The date column name is directly appearing but if i ho with expressions and formatting then only value and item is appearing. Pls help
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
37 | |
36 | |
23 |
User | Count |
---|---|
42 | |
39 | |
30 | |
29 | |
28 |