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:
- Compose + Condition where outputs is equal to utcNow('dd-MM-yyyy')
- Condition where Send Date is equal to utcNow('dd-MM-yyyy')
{"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
