Bad request error while workflow load the data to azure cosmos DB by using  create or update item in logic app

Hi @Ragunath Gunasekaran ,

Thanks for reaching out to Microsoft Q&A.

We connected over MS Teams and the issue is now resolved. Please find the summary of our discussion and resolution below.

Issue:

• Bad Request error typically indicates that Azure Cosmos DB rejected the request due to invalid JSON payload or incorrect connector configuration.

Cause:

• Missing partition key LoadId from SharePoint trigger.

Resolution:

• Provided Logic app Managed Identity Cosmos DB Built-in Data Contributor role in Cosmos DB. Used below command to add Role assignment.

    az cosmosdb sql role assignment create --account-name comos-db-no-sql --resource-group comsos-db-rg --scope "/" --principal-id logic-app-managed-identity-object-id --role-definition-id /subscriptions/sub-id/resourceGroups/comsos-db-rg/providers/Microsoft.DocumentDB/databaseAccounts/comos-db-no-sql/sqlRoleDefinitions/00000000-0000-0000-0000-000000000002
  

• Looked into Application Insights to find the exact error. And the error indicated that no Partition key was supplied from SharePoint source.
• We made sure it’s well-formed JSON. Ensured to include an “id” property (type string) and the partition key property that container is configured to use.