Formula if text change the color to be change in a textlabel

Like (0) Share

Report

Posted on 3 Oct 2020 14:14:01 by Rabbanisyed

259

i have the filed called status having 3 options "Open" ,closed" , "progress"

in the gallery have all the controls in place and the data is displaying perfectly, what i wanted is get automatically change the

colors to specific status

if status = open then color = red or status= closed color=x etc...

Categories:

General Questions

All responses (4)

Answers (1)

Verified answer

Rabbanisyed 259 on 03 Oct 2020 at 16:07:32

Like (0)

Report

Re: Formula if text change the color to be change in a textlabel

I have solved this by using the COLOR from the Formula bar for the textbox i wanted to change the color dynamically
coloer:
If(ThisItem.Status.Value="Open",Red,Green), once the form is loaded it change the colors accordingly
Rabbanisyed 259 on 03 Oct 2020 at 15:20:55

Like (0)

Report

Re: Formula if text change the color to be change in a textlabel

still getting the error, i have shared the error, what exactly i need is when the form is loaded it has to change the color based on the status user filled during the submission of the form.
is their anyway to have conditional formula in PowerApps??

Thanks and regards for the response.

god blessings
Rabbanisyed 259 on 03 Oct 2020 at 15:00:37

Like (0)

Report

Re: Formula if text change the color to be change in a textlabel

i am fetching the data from SP in to Gallery where the text control having Field as and showing resolved"
i set the color of the field (status) to green now wanted to change the color depending status
Pstork1 66,452 Most Valuable Professional on 03 Oct 2020 at 14:32:14

Like (0)

Report
Re: Formula if text change the color to be change in a textlabel

Are you trying to change the color of the whole cell in the gallery or just a label control in the gallery for each item? If its a label then the formula would be something like this in the Fill of the label in the default cell in the gallery.

If(ThisItem.status.Value = "In Progress",Yellow,If(ThisItem.status.Value="Started",Green,White))

Where status is the field showing the result of a status dropdown (Choice) column.