Resolve “ownerid” error while Retrieving list of Teams via flow in Dataverse(Current Environment) Connector

For more details, please check out my old blog here

I had a requirement to get all teams based upon user, so I thought to use Flow on creating action, and ran into a rather odd error recently when I was trying to use a FetchXML query to retrieve a list of Teams using the List Records Connector in a flow,

And I got an error saying “Key property ‘ownerid’ of type ‘Microsoft.Dynamics.CRM.team’ is null. Key properties cannot have null values.”

SOLUTION

The flow looks for ownerid, to do so you need to put ownerid in FetchXML query but ownerid is not there in teams, So I end up using “Alias=”ownerid” Below is the updated Fetch XML

use the same FetchXML to resolve the issues

#PowerApps #PowerAutomate #Microsoft