Verification of complex column types in Gallery and Form

[VFPowerAppsUser]

In my app I have integrated indicator icons which displays if a field is left blank but should be filled depening on the status of the flow. I have this indicator icon integrated into my Gallery.

I am using the Fill property to fill the icon (circle) red or transparent, depending on the need to alert.

Fill property of the icon in the Gallery:
If(ThisItem.ERHSCutDownVersion.Value=Blank(),
If(Or(ThisItem.Status.Value="3 - Documentation",ThisItem.Status.Value="4 - PQQ evaluation finished",ThisItem.Status.Value="5 - Bids evaluation finished",ThisItem.Status.Value="6 - Closed"),
Coral,
Transparent),
Transparent)

This works with this kind of column. The column ERHSCutDownVersion is a choice column where you can select just one entry. Now, I have still another column (ContractAwardTo) that I would like to verify which is of type choice as well. However, in this other column ContractAwardTo multiple values can be selected. The same way of verification is not working for this kind of complex column type.

What is the work around to achive the intened outcome? Thank you for any hints.

[v-jefferni · Accepted solution]

Hi @VFPowerAppsUser ,

Please try below formula:

If(IsEmpty(ThisItem.ContractAwardTo.SelectedItems.Value) || IsBlank(ThisItem.ContractAwardTo.SelectedItems.Value),
If(Or(ThisItem.Status.Value="3 - Documentation",ThisItem.Status.Value="4 - PQQ evaluation finished",ThisItem.Status.Value="5 - Bids evaluation finished",ThisItem.Status.Value="6 - Closed"),
Coral,
Transparent),
Transparent)

Best regards,

[VFPowerAppsUser]

It is a bit embarrassing to say that my initial formula did not work correctly. The reason is that the "=Blank()" did not do the job. Changing to "IsEmpty()" and "IsBlank()" is doing it indeed. Thank you for this hint.