Answered

Filling a square based on a record from Excel

(0) Share

Report

Posted on by PatrykPlaska

Hi, I was looking for a solution on the forum but I couldn't find it. It needs a square that is not in the gallery to be colored based on the record from excel. The data to excel is sent using buttons and the patch function. In the excel file, I have two columns, the first date and the second status. Based on the status column, I want it to fill the square for a given color. For example, x = Color.Green, Y = Color.Blue. Thank you for contributing

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

HI @PatrykPlaska , Could you elaborate more with some screenshots please?

Thanks,
ANB

Was this reply helpful? Yes No
PatrykPlaska 17 on at

Like (0)

Report

Hi @ANB , there are screens of power apps and excel. The square with arrow next to it is not in gallery.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @PatrykPlaska Your code for Fill property of square which is in gallery will be this:

Switch(ThisItem.Status, "No accidents", Color.Green, "Near misses", Color.Blue, "Non LTI", Color.Yellow, "LTI", Color.Red, "Day Off", Color.Black)

For the square which is not in gallery and depending upon the selection in gallery, the Fill property will be

Switch(Gallery.Selected.Status, "No accidents", Color.Green, "Near misses", Color.Blue, "Non LTI", Color.Yellow, "LTI", Color.Red, "Day Off", Color.Black)

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

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
PatrykPlaska 17 on at

Like (0)

Report

It dosent work. There is error about ThisItem.Status "The name is invalid. 'ThisItem' was not recognized." And i had to change "," to ";" becasue i dont know why in polish version of powerapps it had to be like this.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

@PatrykPlaska Status is Choice column? Also are you are adding the above code for Fill property of square which is in gallery or out side the gallery?
I have also edited previous response.
Thanks,
ANB

Was this reply helpful? Yes No
PatrykPlaska 17 on at

Like (0)

Report

@ANB This is a Value Column, and im adding the code to squre that is out of gallery. I tried both codes, the 2nd one is giving no errors but it does not change the color of the square.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

HI @PatrykPlaska , The 2nd code will work when you select any record in gallery. Could you share screenshot of 2nd code.

Thanks,

ANB

Was this reply helpful? Yes No
PatrykPlaska 17 on at

Like (0)

Report

Hi @ANB , there is a screenshot of 2nd code.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

@PatrykPlaska What happen when you try to select different records from gallery? Also Status column in your excel is of choice type? I mean you choose from dropdown in excel?

Thanks,

ANB

Was this reply helpful? Yes No
PatrykPlaska 17 on at

Like (0)

Report

@ANB If i select diffrent record from a Status column nothing happend. Andhow can I check what kind of column it is, because I think it's a value column that pops in the record set by the button using the patch function.

Was this reply helpful? Yes No