Convert PowerApps Checker SARIF files to Excel using Power Query

The PowerApps Checker Powershell module introduces the ability to script the validation of solution files to analyze them for following best practices. This is an improvement over the Solution Checker which involves submitting solutions for validation through a web interface. One significant difference between the two tools is the Solution Checker makes the output available for download as Excel files whereas the PowerApps Checker outputs SARIF files.

SARIF files use the JSON file format and are meant to be consumed by other applications to display the information a human readable format. The SARIF website shows three existing tools that have been built for viewing these files, unfortunately they’re not conducive to being used in a team-based environment where the information needs to be shared, like Excel files can be.

One way to quickly convert these SARIF files to Excel is with Excel’s Power Query and its support for JSON files. After using the Power Query editor to create the query, it’s then possible to access the query in its raw text-based format so that it can be edited, or shared with others.

Read more