Answered

Date Not Matching Today's Date

(0) Share

Report

Posted on by 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:

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TrucoBen123 22 on at

Like (0)

Report
Copy link

Link copied!

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

For your reference this is my flow:

Was this reply helpful? Yes No
Verified answer

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No