SharePoint Troubleshooting and Updating with Power Apps and Power Automate

In this video, you will learn how to troubleshoot some duplicate filter values in your SharePoint list using Power Apps. Once you find out the issue is extra spaces at the end of your text you will then see different ways to fix the problem. You will use Power Apps Patch, ForAll, and Collect as some ways to make updates.

Then you will switch gears to Power Automate flow to fix the problem at scale with Get Items, Update Item, Apply to each, Pagination, and a couple of expressions. This is a better method.

Also, as an added bonuses, this is all using production data, so we talk about how to go slow and test before just blowing up everything. A great video of practical guidance to fix an annoying problem.

0:00 It Starts
1:43 A walkthrough of the problem with our production SharePoint list, duplicate names showing up when filtering
3:44 Create a Power Apps app to try to find out why we see duplicates
5:03 Use the Len function to check the length of the records
5:50 Use the Trim function to remove the spaces from the text string
6:50 How to use the Patch function to fix the issue dealing with the Complex Column type of Choice
9:36 Put the Choices function in a dropdown so you can see how the complex record is formatted
12:12 Use ForAll to fix all of the records by using Patch and a collection
16:30 We talk about doing it by first updating a collection but don't actually show it (video got too long)
17:04 Create a Power Automate flow to fix the problem in a better way

18:45 An Apply to each loop automatically gets added by using Dynamic Data in Update Item for SharePoint
19:06 Making a Choices column dynamic in Power Automate flow
19:20 Using the Power Automate Trim string function
21:52 Get a single item for testing via Odata query filter in Get Items action
23:00 Why Power Automate is better than Power Apps
28:35 Use the Length Power Automate flow expression to count the number of records that are returned
32:14 How to deal with larger data sets via pagination setting

Power Apps Consulting and training at https://www.PowerApps911.com