Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Integrating Excel Spreadsheet & Power Automate Flow

Posted on 22 Nov 2024 21:25:09 by
I have an excel spreadsheet that automatically calculates due dates for various tasks involved in an event planning process. I'd like to use power automate to update the due dates of the corresponding tasks in Microsoft Teams Planner. Every way I have tried has some error or another. The due dates are in an excel table set up with sets of columns that have task description>>due date>>status organized by the time ranges in which they need to be completed. Ideally, Power Automate would pull just the due date and enter it into the already built out task in Planner, but I'm not sure if that's a possibility.
 
Right now, I'm trying to use a manual trigger, then the "list rows present in a table" action to pull the data, then the "update a task" action. I'm getting an error message that says: Input parameter 'body/dueDateTime' is required to be of type 'String/date-time'. The runtime value '"45613"' to be converted doesn't have the expected format 'String/date-time'.
 
I'm new to Power Automate so apologies if this is unclear or lacks enough detail, but any advice would be appreciated.
  • Srini007 Profile Picture
    Srini007 2,715 on 23 Nov 2024 at 15:43:14
    Integrating Excel Spreadsheet & Power Automate Flow
    Hi,
     
    Check the "list rows present in a table" action Datetime Format parameter is set to ISO 8601, if still you are facing issue, then check below link for your reference
     
     
    If I have answered your question, please mark it as the Answered. If you like my response, please give it a Like.
     
    Regards,
    Srini

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,111

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard