dataflow, Dataflow, Dataverse, PowerApps, Uncategorized

Dataflows for Power Apps: transform fixed-width text files

What is a fixed width text file? Data in a fixed-width text file is arranged in rows and columns, with one entry per row. Each column has a fixed width, specified in characters, which determines the maximum amount of data it can contain. No delimiters are used to separate the fields in the file. Could we load data from… Continue reading Dataflows for Power Apps: transform fixed-width text files

Common Data Service, dataflow, Dataverse, PowerApps

Dataflows for Power Apps: cyclic reference error with multiple data sources when you start with empty query

As simple as this: if you don't believe in solutions with Dataflow and just copy queries across most likely you are going to get the following error: I had multiple data sources: Dataverse and CSV file. Because I didn't go through the normal order for steps but just started with an empty query and just… Continue reading Dataflows for Power Apps: cyclic reference error with multiple data sources when you start with empty query

Common Data Service, dataflow, Power Platform, Uncategorized

❤Dataflow❤ with Power Apps: bulk update for CDS records

This article is using a test data because using customer data is wrong. The rest is very practical stuff. If you don't use Dataflow for Power Apps still I think you should. I am trying to solve a typical problem. We've got a Choice column Business Type for Account (for example). We need to remove… Continue reading ❤Dataflow❤ with Power Apps: bulk update for CDS records

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❤