Imagine a case where you want to apply the same JSON custom formatting in all SharePoint list views for a list and this list has a lot of views. You would need to do it one by one in all views, or you could use PowerShell to script it. But not all the times you are able install PowerShell in your work computer.
That’s when Power Automate comes handy, we can create a button Flow to run this action for us.
The same idea can even be reused to be part of a bigger automation process.
Check out how to do it.
Create a flow with a manual trigger and the following parameters:
- Site URL
- List Name
- Custom Formatter
And initialize variables to associate all the 3 values as below (for clarity and later manipulation).
Escaping Single Quotes from the JSON content
With a compose action as below, use the following expression to escape single quotes from the CustomFormatter, otherwise you may run into issues if the content has a single quote:
More About This Author
SharePoint and Office 365 Consultant/Developer always trying to get the best from Microsoft stack (Microsoft 365/Azure/Power Platform and related stuff).
Living in Ireland since 2018, I had previously worked in Brazil as a consultant/developer for Office 365, SharePoint and related technologies for almost 10 years.
- ModernWorkplace2022.11.19Hiding the New and Upload buttons from a SharePoint document library using JSON list formatting
- ModernWorkplace2022.10.25Build powerful Adaptive Card experiences for Teams using Cards for Power Apps
- ModernWorkplace2022.10.15Ignite 2022: Curated list of posts from Microsoft related to Microsoft 365 and Power Platform
- ModernWorkplace2022.10.08Calling Graph API using a flow and manipulating the results from Power Apps using the ParseJSON function