Working with large or complex JSONs can be intimidating, The key is to understand the JSON structure you are working with. If you’re struggling trying to extract data from a JSON, then this post is for you! JSON Structure The […]
Here is a simple trick to get around one of the limitations of dropdown controls, the fact that they can’t display data from related tables. In a dropdown control, only data in columns native to the table specified in the
Default Record By default, when a screen containing a Gallery is loaded, the first item in the Gallery is automatically selected. Sometimes this is helpful and sometimes not If you prefer to not have any record selected when the screen
Combining 2 Columns Sometimes it really helps to combine 2 columns to display in a dropdown control, for example if you have first and last names in separate columns Its straightforward to do that by using the AddColumns function within
Navigating Dataverse – 2024 Update In 2021, I wrote a series of blog posts on how to navigate up and down a chain of Dataverse tables At the time, finding the related parent or child records was straightforward using dot
The Date Picker Control – When using a Date Picker control to select a date and store it in Dataverse, the format of the stored content depends on whether the Dataverse column has been defined as ‘Date only’ or as
Filtering on Date Fields – I’ve always found working with Dataverse date columns in Power Apps temperamental. I’ve always found a solution that works, but the nagging doubt has remained that I wasn’t completely clear why there was a problem
There’s a Chinese proverb that says “A journey of a thousand miles begins with a single step” and that equally applies to coding complex formulas in Power FX I was asked about a previous post Filter Based on Child Data, and
Filter based on Child Data – Here’s a quick demo on how to get a filtered list of records from a parent Dataverse table based on data in a child table In my user case, I have a simple Dataverse structure
Multiple Search Criteria – If you want to have multiple criteria to filter the contents of a gallery in a Canvas App, here is the best way to achieve it! My user case is that I want to be able
Lookup Columns – In this post I’ll show how to use Power Automate to access lookup columns and change multiple child records in Dataverse based on the parent table’s record value Boxes & Files In my example, I have a
When building a Canvas app screen, sometimes there’s not enough screen space for all the data you want to display. Possible solutions are to implement vertical or horizontal scrolling or add tabs to the screen, but a nice alternative can
