Date Not Matching Today's Date

[TrucoBen123]

Hi, I am trying to do a birthday message in power automate where the automate process will detect today's date and go through a excel list full of date of births, however the power automate only managed to capture some birthdays as they are listed as general format but for those dates with Date Format, it is unable to detect the date. Please assist.

General Format Date:

Date Format Date:

[jinivthakkar]

@TrucoBen123 I was able to reproduce the issue, I think when we format the excel it has tables, some row values have are of type general while some of them are change to date and hence the issue I guess because when flow reads the excel, date values are returned as number (e.g. 27406) and general are returned as date (29/12/1971) and so on

This is what I did

so based on what is returned I have condition check, convert the dates as required and using contains/starts with I have done this.

Please try this and let me know if this works for you.

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[TrucoBen123]

Hi @jinivthakkar , can I see the full flow process?

For your reference this is my flow:

[jinivthakkar · Accepted solution]

@TrucoBen123 buddy I have attached images for my entire flow, please click picture 1 by 1.