You’re offline. This is a read only version of the page.
When the date should be equal and send a email , it return me false
I'm having the same issue. Things may have changed since this original post, perhaps someone can help me.
(Recurrence = 1 minute for testing purposes)
I have a table with dates (format 13-09-2023), subject headings and messages.
I want my flow to find a date in a row in a table and if the date is today, I want a message to be sent to a channel.
Everything is running successfully but it seems that I'm struggling with my date format. I've tried this multiple different ways but I still have the same issue. This way seems to be the cleanest, it's my date that seems to be the biggest issue.
I don't think my condition is working as the date in the table is not = to today's date. It seems that even though my table date has the right format, it seems to be adding the input date 13-09-2023 as a number 45182
In the 'List rows present in a table' OUTPUTS, it includes "Send Date":"45182" - I'm not sure if this is the reason why I'm struggling?
I've tried a few different combinations of Apply to each, but none are working:
Share
Report
All responses (
Answers (
{"statusCode":200,"headers":{"Cache-Control":"no-store, no-cache","Pragma":"no-cache","Transfer-Encoding":"chunked","Vary":"Accept-Encoding","Strict-Transport-Security":"max-age=31536000; includeSubDomains","x-ms-request-id":"xxx;xxxx;xxxxx","OData-Version":"4.0","X-Content-Type-Options":"nosniff","X-Frame-Options":"DENY","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"false","x-ms-apihub-obo":"false","Date":"Wed, 13 Sep 2023 11:08:45 GMT","Content-Type":"application/json; odata.metadata=minimal; odata.streaming=true","Expires":"-1"},"body":{"@odata.context":"https://excelonline-ne.azconn-ne-002.p.azurewebsites.net/$metadata#drives('xxx')/Files('xxx')/Tables('xxx')/items","value":[{"@odata.etag":"","ItemInternalId":"xxx","Send Date":"45182","Subject Heading":"Welcome to MST","Message":"Today is the first day. "}]}}@ScottShearer @v-bacao-msft @Anonymous @Dokushi
It means what you think it would - that the column "MyDate" on their "CustomList" list is equal to today (their formatted date using utcNow()).
You would likely have to get your date into a variable and use a Conditional action to compare against it, however, not filter from a list in a "Get items" block, like they are.
"MyDate eq" what does it denote, does it look at the date column of the table, because in my case i am using a onedrive business connector, and i want it to get rows where my date column is equal to todays date, but the odata filter doesnt show columns on the table
Thank you for the help
@Anonymous
While I agree with @v-bacao-msft , you might want to change your Flow to use an OData filter rather than a condition. This will make your Flow much less complicated. The only rows that are returned are those that meet your criteria - no need for a condition. More information on using OData filters can be found here.
See my example below:
Hi @Anonymous ,
Please try the following configuration:
You could check the value of Compose after Flow is executed.
Best Regards,
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
