cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TrucoBen123
Frequent Visitor

Date Not Matching Today's Date

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:

TrucoBen123_0-1638349349599.png

 

Date Format Date:

 

TrucoBen123_1-1638349379864.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jinivthakkar
Super User
Super User

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

View solution in original post

3 REPLIES 3
jinivthakkar
Super User
Super User

@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

 

jinivthakkar_0-1638356923268.png

 

jinivthakkar_1-1638357395464.png

 

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.

 

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

 

 

For your reference this is my flow:

TrucoBen123_0-1638405089789.png

 

 

TrucoBen123_1-1638405110646.png

 

 

jinivthakkar
Super User
Super User

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,558)