web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Issue in Date format i...
Power Automate
Answered

Issue in Date format imported from Excel

(0) ShareShare
ReportReport
Posted on by Nanig 23

Hi 

The excel contains a table with email id and alert date. Based on this data, a mail has to be sent to the person.

-Outlook has to pick email id from the excel table

-And the trigger for sending the email should be based on alert date.. i,e if alert date is Today s date then a mail has to be sent. I have created the attached flow. The Alert date in excel format is being reflected as number. So Flow is not being executed in right manner.

How to change the format of date which is linked with excel?Capture.PNG 

Categories:
Using connectors
I have the same question (0)
  • Verified answer
    RobElliott Profile Picture
    RobElliott 10,420 Super User 2026 Season 1 on at

    @Nanig Excel formats dates as an integer so to use them in your flow you need to convert that integer to a date. You can do this with a Compose action and add the following expression (where CCheck is the column in my spreadsheet with the date, so change it to your column):


    formatDateTime(addDays('1900-01-01', add(int(items('Apply_to_each')?['CCheck']),-2)), 'yyyy-MM-dd')

     

    You then select from the dynamic content the output of the Compose action.

     

    If you are doing a comparison of the output against today's date then always make sure you use yyyy-MM-dd.

     

    Rob
    Los Gallardos
    If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

  • Nanig Profile Picture
    Nanig 23 on at

    @RobElliott  Thanks a lot for the solution, I had been trying that since long time. 

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 283

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans