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
Good canvas app naming conventions for variables and collections ensure their purpose is clear and understood. A consistent and recognised format both helps the App Maker and assists other developers conducting a peer review or handover The PowerApps Canvas App
Power Apps delegation is the processing of a query within the data source itself rather than by Power Apps. Delegable queries are far more efficient because the query is executed quickly on the server and the full set of results
January 2024 Update – Microsoft has improved the table navigation. Read about the lastest functionality: Navigating Dataverse Tables. In this post, I’ll show how the Filter function can be used to identify Dataverse relations, including Child and Grandchild rows and
Need to sort a Dataverse Choice column in a Canvas app? It seems like it should be straightforward to do, but unfortunately it’s not! Read on to see the possible options To sort a Dataverse Choice column, your first thought
A Short post playing around with embedded tables in collections Contents Create an Single Column Embedded Table within a Collection ClearCollect( colA, { Month: [ “Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun” ] } ) Extract the Contents of the Table
The Table function is used in Power Apps to manually create a Table within a Power App control rather than retrieving data from a networked data source (such as SharePoint) or a Collection. But what is it used for and
Do you want to retain user settings or preferences when an app is closed, but not have to write back to a data source? Power Apps SaveData and LoadData functions allow you to save data locally to a mobile device
In the last post I set myself the challenge of creating an dynamic Power Apps Dropdown box that shows the number of records in a table that match the Dropdown selection criteria. The requirement was to not have hardcoding so
There is a simple and very effective way to select multiple Records in a Gallery. The TemplateFill property of Galleries used with the tips below gives complete control so both individual and multiple Records within Galleries can be selected and
Records in Collections can be filtered before being displayed in Galleries. Dropdowns are a great way to do this and using a little configuration their use can be made intuitive, effective and user friendly Filter Galleries – 3 Great Tips