Trying to automate Excel file import to Planner Premium using Power automate

Question

While attempting to set up a Power Automate flow to transfer task data from an Excel file stored in OneDrive or SharePoint into Planner Premium, several issues have been encountered. (Sorry if the error "snippet" is displaying the wrong way - I don't use this site a lot - but appreciate any help).

Steps Attempted

Created a new flow in Power Automate
Selected the trigger: "When a file is created or modified (OneDrive for Business)" to monitor the Excel file.
Added an "Excel Online (Business)" action to read rows from the file.
Attempted to add an action to create tasks in Planner Premium based on the Excel data using DataVerse.
Copy of the flow & Errors are below:

Text of error:

Action 'Perform_an_unbound_action' failed: Error identified in Payload provided by the user for Entity :'', For more information on this error please follow this help link https://go.microsoft.com/fwlink/?linkid=2195293 ----> InnerException : Microsoft.OData.ODataException: The annotation 'odata.context' was found. This annotation is either not recognized or not expected at the current position. at Microsoft.OData.JsonLight.ODataAnnotationNames.ValidateIsCustomAnnotationName(String annotationName) at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadEntryInstanceAnnotation(String annotationName, Boolean anyPropertyFound, Boolean typeAnnotationFound, PropertyAndAnnotationCollector propertyAndAnnotationCollector) at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadODataOrCustomInstanceAnnotationValue(IODataJsonLightReaderResourceState resourceState, PropertyParsingResult propertyParsingResult, String annotationName) at Microsoft.OData.Json…
    Troubleshoot Web API client errors - Microsoft Dataverse | Microsoft Learn
    Provides resolutions for the common client errors that occur when you use the Dataverse Web API.

Flow Overview

Error

microsoftdeveloperdesigner · Accepted Answer · 2025-09-24 22:45:44Z

1

Planner Premium (Project for the web) tasks are created via Dataverse “Project Schedule APIs” (not the classic Planner connector). Also In Power Automate you must call Microsoft Dataverse >> Perform an unbound action with the exact parameters those APIs expect.Finally, Your error (The annotation 'odata.context' was found … not expected) means the body you sent contained response metadata (like @odata.context) from some previous step. Dataverse actions expect only the parameter object(s)—never the full OData response payload.

so in Dataverse:

Create operation set >> msdyn_CreateOperationSetV1
Create rows (staging) >> msdyn_PssCreateV1 (repeat per row or in a loop)
Execute operation set >> msdyn_ExecuteOperationSetV1
Abandon operation set on failure >> msdyn_AbandonOperationSetV1

answered Sep 24 at 22:45

microsoftdeveloperdesigner

3656 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trying to automate Excel file import to Planner Premium using Power automate

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related