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.