web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Formatting JSON to sho...

Power Automate

Answered

Formatting JSON to show a newly added column header

(0) Share

Report

Report

Posted on by DogRiverRat

So I hacked my way using Flow into adding a new column into a List I imported into SP from an Excel spreadsheet. However, the new column header doesn't show up by default into the List current view.

Hoping to add a little logic to my Flow so that the new column header shows up. I think it's related to setting hideColumnHeader to "false" but I don't understand how to construct the appropriate JSON.

Actually, while I asking, thinking likely possible (maybe ??) to combine the above with the following additionalRowClass JSON as well into the same update view call ?

{
"schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"additionalRowClass": "=if([$CSS_x0020_Required] == 'YES', 'sp-field-severity--good', '')"
}

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @DogRiverRat,

You can use the addProperty() function to combine these column headers into the JSON, For example:

setProperty(json('{ "firstName": "Sophia", "surName": "Owen" }'), 'surName', 'Hartnett')

It will be:

{ "firstName": "Sophia", "middleName": "Anne", "surName": "Owen" }

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No

Join the conversation