Tip #1443: Let SharePoint deal with rogue data
Using Power Automate to import data into a SharePoint list can be challenging when the data is not clean. The SharePoint connector may encounter errors if there are blank values or non-numerical garbage in number columns. One solution is to change the column type to a single line of text, import the data, and then change it back to a number. This will remove all invalid entries and leave only valid numbers. This workaround is useful when dealing with a large number of columns with similar data quality issues.
Article 12m
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time