Power Apps

set specific color for Gallary items base on the text label outside the data source.

(2) Share

Report

Posted on by GGG666

190

Dear experts

Good day.

I would like to set color for Gallary items that has been scored base the the Text lable from other data source.

Would you please help to provide some guidance on it. ?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!
Hello @GGG666,

If your score is coming from another data source, you can use a LookUp function to bring that value into your Gallery and then apply the condition for color based on it.

Select the that Rectangle or if you want to apply gallery in Gallery then select the Template Fill property in Gallery.

Example

With( { scoreValue: LookUp(OtherDataSource, ID = ThisItem.ID, Score) }, If( scoreValue >= 45, Color.Green, scoreValue >= 35, Color.Orange, scoreValue >= 0, Color.Red, Color.Gray ) ) //OtherDataSource - Replace with your other data source //ID = ThisItem.ID - Replace this condition based on your configuration.

Note: Please make sure replace the above lookup condition as per your configuration. Also, please replace the color condition based on your score range.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(1)

Report
Copy link

Link copied!
To set color for Gallery items based on a value from another data source, you need to match records using a common key (e.g., QuestionID) and use LookUp() to retrieve the score.

Then apply conditional formatting (If/Switch) in TemplateFill or control properties based on that value.

Try like below :

Identify common key

You need a common field between:

Gallery data → e.g. QuestionID

Score data → e.g. QuestionID

Get score from external source

Use LookUp() inside gallery

Example:

LookUp( ScoreDataSource, QuestionID = ThisItem.QuestionID ).Score

Apply color in TemplateFill (or Label Color)
Example (color based on score)

If( LookUp( ScoreDataSource, QuestionID = ThisItem.QuestionID ).Score >= 8, Color.Green, Color.Red )

Was this reply helpful? Yes No
GGG666 190 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Thanks for your reply，Though “ThisItem” in the code is not recgonized

Was this reply helpful? Yes No