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)

Common Data Service, Flow, Power Automate

CDS current connector: Filter expression. My Flow doesn’t trigger!”

I thought you will love this one. It's that type of "Help! My Flow hasn't get triggered" thing which we all love. How to reproduce For the CDS entity which has some existing records then a new optionset field has got created. As a result some records may not have this field populated. If you… Continue reading CDS current connector: Filter expression. My Flow doesn’t trigger!”

man is trying to roll a large rock uphill
Common Data Service, Flow, Uncategorized

How to get it right: “List records” just-first-record lookup value expression for CDS current connector

Sometimes I use my own blog to find some information which I am keeping forgetting. I am always forgetting how to do THIS so I keep it here. Problem: from the list of items retrieved via List records action for CDS current connector i would like to pick up the first item and get the… Continue reading How to get it right: “List records” just-first-record lookup value expression for CDS current connector

Common Data Service, Flow, Uncategorized

Power Automate CDS (current environment). Set Regarding.

While using CDS (current environment) connector for the Regarding property which is separately listed for each entity would you assume it's unnecessarily to prefix a dynamic property value with a type ? Well, unfortunately, you have to. The same way as for other lookups, you have to specify type prior the dynamic property. In my… Continue reading Power Automate CDS (current environment). Set Regarding.