Forum Discussion
Export SharePoint list retaining SharePoint formatting
I had a request to see if we can export our sharepoint list to excel but retain the color coding and formatting. Is there a way to do this?
ganeshsanap, we have users in the C-suite space that will probably print this SharePoint list out. The color scheme matters because it helps them visually see if a position has urgency. Some of them want to export it to excel so they have a list. I know kind of silly as it should stay in SharePoint but they asked me to look into it. Maybe there is some way to use Microsoft flow to creat some sort of a report in HTML or something. Not sure.
VeeExcelLearnnope, it won't retain the JSON column formatting. An HTML table could be created in a flow in Power Automate but you would have to go to quite a lot of effort to re-create the formatting. There is nothing in Power Automate that will keep the formatting from the SharePoint list.
Just give your users the link to the SharePoint list and make them read-only users. Or add a List web part to a page in your SharePoint site and give them the link to that page.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)