flow-condition -compare if today date is equal with a date on sharepoint liste, if yes, send email

[Anonymous]

When the date should be equal and send a email , it return me false

[v-bacao-msft · Accepted solution]

Hi @Anonymous ,

Please try the following configuration:

You could check the value of Compose after Flow is executed.

Best Regards,

[ScottShearer]

@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:

[Anonymous]

Thank you for the help

[Dokushi]

"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

[Anonymous]

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.

[HelloImNewHere]

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 

[EBookspan]

HelloImNewHere: make sure your column is formatted as a date column.