Video

Show all results from a #SharePoint list Search in #PowerApps. 100% effective. This is a delegation workaround for the search function. And it does not require premium licensing. I have found a way to search a #SharePoint list in #PowerApps and return any records with a matching substring. The Power Apps Search function does not support delegation for the SharePoint connector. Instead, we can u...

Generate row numbers for a Power Apps collection with this formula. Copy and paste this code into your own app. Here’s how it works: The ForAll function returns a table of values with the row number included. First, we use the the CountRows function to determine how many rows are in the original collection and the Sequence function to generate the row number. Then we Patch the row numbers into ...

Hide the Power Apps navigation bar by adding hidenavbar=true to the end of the app's play URL. I recommend you do this when providing users with a link to any canvas app so it display as large as possible on the screen. Here's a quick summary of how this tip works. Read the full article for this video at MatthewDevaney.com 🔗 www.matthewdevaney.com/power-apps-tip-hide-the-navigation-bar-in-play-...

This strange hack makes it possible to quickly update the style of all DataCardKeys and DataCardValues in a Power Apps form. Normally its simple to update multiple controls at once. Just select a group of controls then change the desired problem. But a Power Apps form makes it impossible to select multiple controls from different data cards. Impossible unless you use this Power Apps hack… 1. Se...

Remove the duplicate rows from any Power Apps collection with this 1 line of code. Here's how it works: the Distinct function returns a one-column table of unique values for a field. But when we use ThisRecord instead of a column name it results in a one-column table of unique records. Then we loop over the one column table using ForAll to extract the rows into a multliple column table. Read th...

Power Apps find & replace tool is a powerful new feature. You can use it to quickly rename all occurrences of a variable or collection in your app. It is no longer necessary to change variable names one-by-one Read the full article at MatthewDevaney.com 🔗 www.matthewdevaney.com/rename-variables-in-power-apps-with-1-click/

Download the PowerApps game for FREE on the Community Gallery: powerusers.microsoft.com/t5/Community-App-Samples/Crossword-Countdown-Word-Game-feat-170-000-Word-Dictionary/td-p/465254