Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Issue in Date format imported from Excel

(0) ShareShare
ReportReport
Posted on by 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 

  • Nanig Profile Picture
    Nanig 23 on at
    Re: Issue in Date format imported from Excel

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

     

  • Verified answer
    RobElliott Profile Picture
    RobElliott 9,993 on at
    Re: Issue in Date format imported from Excel

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

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics