Unanswered

Conditional template fill based on dropdown selection

(0) Share

Report

Posted on by monks_

Hello!

I am trying to change the template fill of the rows in a gallery based on their relation to a dropdown. I'm using two Sharepoint lists as databases and relating them through a field. The problem I'm facing is that, instead of changing the template fill of a specific item, all items change color based on the last input of the dropdown. Here's a sample of my code:

If(
 ThisItem.IsSelected,Color.MediumPurple,
 LookUp(
 'list',
 'topic field'=ThisItem.TopicID && Location=varSelectedLocation,true
 ) && Radio1.Selected.Value = "No",
 Color.DarkGray
 ,
 LookUp(
 'list',
 'topic field'=ThisItem.TopicID && Location=varSelectedLocation,true
 ) && Dropdown1.Selected.Value = "bad evaluation",
 Color.OrangeRed
 ,
 LookUp(
 'list',
 'topic field'=ThisItem.TopicID && Location=varSelectedLocation,true
 ) && Dropdown1.Selected.Value = "good evaluation",
 Color.LightGreen
 ,
 ...
)

Any ideas of what might be wrong?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Community Power Pla... on at

Like (0)

Report
Hi @monks_ ,

In 1st condition, ThisItem.IsSelected seems to apply to all items in the gallery, and thats why all items are changing color based on the last input of the dropdown.

Could you please try this one -
If( ThisItem.IsSelected, Color.MediumPurple, LookUp( 'list', 'topic field'=ThisItem.TopicID && Location=varSelectedLocation, true ) && Radio1.Selected.Value = "No", Color.DarkGray, ThisItem.DropdownValue = "bad evaluation", Color.OrangeRed, ThisItem.DropdownValue = "good evaluation", Color.LightGreen, ... )

Was this reply helpful? Yes No
monks_ 8 on at

Like (0)

Report

Hello, @Anonymous!

This doesn't seem to work, probably because I'm not working with a form but with independent fields that relate through a text field similar to ID (in this format: 001, 002, 003...)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Instead of Templatefill, try to add rectangle inside gallery and use this formula on Rectangle's fill property.

Was this reply helpful? Yes No