Excel to Planner - Date

Like (0) Share

Report

Posted on 13 Jul 2021 15:42:25 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 (1)

Answers (0)

ScottShearer 25,236 Most Valuable Professional on 13 Jul 2021 at 16:08:28

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.