News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Excel to Planner - Date

Power Automate - Using Flows

Unanswered

Excel to Planner - Date

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi everyone,

I have a simple flow which creates tasks on planner app from excel data.
The problem seems to be with dates. I have creation date and due date in mm-dd-yy format in my excel table.
Im getting the below error when running the flow

Request your assistance.

All responses Img

All responses (1)

Answers Img

Answers (0)

ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: Excel to Planner - Date

@Anonymous

In your Excel action, go to Advanced options and set the DateTime format to ISO 8601 - I suspect that this will resolve your issue.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,618 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,957 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans