Unanswered

Add Custom Format to a Sharepoint Column when creating it through Power Automate

(0) Share

Report

Posted on by Community Power Pla...

Hey everyone. I'm creating a bit of a complex flow to do some calculations in a Sharepoint list.

I'm having a problem when trying to set a custom JSON format in a column I'm creating with an HTTP call. There are no errors if I try to create the column without any formatting. So I think it has to be in the property I'm assigning the style to or the JSON itself (but it works great If I add it manually to the column through Sharepoint).

Here is a screenshot of the HTTP call:

I'll keep trying in the meantime and post any updates.

If you need more information just let me know and I will provide it.

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on at

Like (1)

Report

Re: Trying to set a Custom Format to a new Sharepoint Column

After a bunch of trial an error, I found out the solution.

The problem here was with the JSON itself. It needs to be as a string, here is the result call:

Spoiler (Highlight to read)
"{\"$schema\":\"https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json\",\"elmType\":\"div\",\"children\":[{\"elmType\":\"span\",\"txtContent\":\"@currentField\",\"style\":{\"padding-left\":\"8px\",\"white-space\":\"nowrap\"}}],\"attributes\":{\"class\":\"sp-css-backgroundColor-BgCornflowerBlue sp-css-borderTop-CornflowerBlueFont\"},\"style\":{\"padding\":\"0\",\"width\":\"=if(@currentField >= [$Capacity], '100%', (@currentField / [$Capacity]) * 100 + '%')\"}}"
"{\"$schema\":\"https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json\",\"elmType\":\"div\",\"children\":[{\"elmType\":\"span\",\"txtContent\":\"@currentField\",\"style\":{\"padding-left\":\"8px\",\"white-space\":\"nowrap\"}}],\"attributes\":{\"class\":\"sp-css-backgroundColor-BgCornflowerBlue sp-css-borderTop-CornflowerBlueFont\"},\"style\":{\"padding\":\"0\",\"width\":\"=if(@currentField >= [$Capacity], '100%', (@currentField / [$Capacity]) * 100 + '%')\"}}"

Was this reply helpful? Yes No
gianmasmec 2 on at

Like (0)

Report

Re: Trying to set a Custom Format to a new Sharepoint Column

Great solution. Could you provide an alternative for choice fields?

Was this reply helpful? Yes No