PowerApps Gallery

(0) Share

Report

Posted on by Sri

559

Hi all,

I am working with PowerApps dashboard which has a gallery. My Data source is SharePoint. My gallery calculates the RAG Color for all the fields and displays it (eg, Time, financial, efficiency are the labels and the respective fields have RAG colors(red, green, amber). Time category has two values to be compared(schedule & commitment). If prjmethod.text ="agile" commitment rag must be viewed in gallery or else schedule rag must be viewed in gallery. This prjmethod differs for every project. Is there any way to change the rag color based on the prjmethod condition.

Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

Yes, in the color property of the label (any field) add an IF statement, for example:

If(prjmethod.text ="agile", Green, Blue)

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
Subscribe to my YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report

I have written this on the fill property of circle:
If(
StartsWith(projmethodlbl.Text, "^Agile") && EndsWith(prjcontlbl.Text, "T & M"),
If(
ThisItem.Commit = "Red",
Red,
ThisItem.Commit = "Amber",
Orange,
ThisItem.Commit = "Green",
Green
),
If(
ThisItem.SCHEDULE = "Red",
Red,
ThisItem.SCHEDULE = "Amber",
Orange,
ThisItem.SCHEDULE = "Green",
Green
))
But its working only for the first condition

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

What should happen if Schedule and Commit are different?

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report
If( StartsWith(projmethodlbl.Text, "^Agile") && EndsWith(prjcontlbl.Text, "T & M"), Switch( ThisItem.Commit, "Red", Red, "Amber", Orange, "Green", Green ), Switch( ThisItem.SCHEDULE, "Red", Red, "Amber", Orange, "Green", Green ))
Firstly change the IF statements for a Switch. If Schedule and Commit are different what should the fill colour be?

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report

Its different only. Based on the projmethod.Text value(agile = commitment & traditional =schedule) the respective rag must be displayed in gallery.

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

@Uthhra what result does this give you?

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report

If I use switch statement I am getting an error "Switch has invalid arguments", Expected color value.

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report

This is how my gallery will look like. Based on condition the rag color is displayed

Screenshot (76).png

Was this reply helpful? Yes No
MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

@Uthhra, What is the original error with the original code?

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report

Since its a gallery its comparing only the first condition Eg(if commit only that related fields are getting RAG colors), second condition is not working.

Was this reply helpful? Yes No