Answered

Patching Value of the Colour of the Fill of an Object into Column in SharePoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

Please help me with the below issue:

I am trying to patch the colour of the fill of an object into a column in SharePoint. But getting error : Expecting text values instead.

Below is the formula that I used:

Patch(
Table_1,
{Title: "1",
Date: Today(),
Category: "Status 1",
value: Status1.Fill}
);

Thanks in Advance

Xiu Min

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Some clarification:

Is Value the name of your column?

Do you want to save the colour name example "Red" as filled in the status?

Kindly show a screen shot of Status on your screen. is it a label

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Please Subscribe to my Youtube Channel
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Yes, Value is the name of the column.
Yes, I want to save the colour name of the fill of the status.
The status is a circle as shown in the screenshot below:
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

See below screenshot:

Fill property only accepts Color type data, you will need to convert the value to Text to save to your list:

So I assume you have 3 kinds of colors for the circle: Red, Green and Yellow, you can use a switch function the detect the color of the icon and get corresponding texts:

Switch( Circle1.Fill, Red, "Red", Green, "Green", Yellow, "Yellow", "" )

Append this to your Patch function:

Patch( Table_1, {Title: "1", Date: Today(), Category: "Status 1", value: Switch( Status1.Fill, Red, "Red", Green, "Green", Yellow, "Yellow", "" )} );

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.