Business Applications, Common Data Service, dataflow, Model-driven

Dataflow for Power Apps: query CDS with OData connector(improved)

Recently I posted about the same issue: https://wordpress.com/post/msolenacrm.blog/1580 . Yesterday I discovered a new way. It looks like OData connector is more friendly than the Web API one. Use FetchXmlBuilder to help you to build the query. Start creating you Dataflow: For the data source on the tab Other pick up the OData connector. For… Continue reading Dataflow for Power Apps: query CDS with OData connector(improved)

Business Applications, Common Data Service, dataflow, PowerApps, Uncategorized

❤ Dataflow for Power Apps: query CDS via Web API❤

In my Dataflow you would like to query CDS data. This is how I you it. Click on New dataflow and enter the name. On the next screen on the tab Other select Web API. Go to your model-driven app Advanced Settings. Select Customizations -> Developer Resources. Copy Instance Web API Service Root URL. Paste… Continue reading ❤ Dataflow for Power Apps: query CDS via Web API❤

Business Applications, Model-driven, PowerApps

PowerApps Dataflow: is your CDS entity primary field name exactly the same as an entity name? Well, don’t.

The Issue: Unable to load data to the existing custom entity on CDS from CSV or Excel via Dataflow. We renamed the primary Name field for our custom entity and this is how it's all started. Error: Load to Common Data Service failed. Details: Bad Request {"error":{"code":"0x0","message":"An error occurred while validating input parameters: Microsoft.OData.ODataException: Does… Continue reading PowerApps Dataflow: is your CDS entity primary field name exactly the same as an entity name? Well, don’t.