cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
VFPowerAppsUser
Frequent Visitor

Verification of complex column types in Gallery

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.

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @VFPowerAppsUser ,

Using the column you posted, try this structure

If(
   ThisItem.ERHSCutDownVersion.Value = Blank(),
   If(
      Or(
         "3 - Documentation" in ThisItem.Status.Value,
         "4 - PQQ evaluation finished" in ThisItem.Status.Value,
         "5 - Bids evaluation finished" in ThisItem.Status.Value,
         "6 - Closed" in ThisItem.Status.Value
      ),
      Coral,
      Transparent
   ),
   Transparent
)

 

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.

Visit my blog Practical Power Apps

View solution in original post

3 REPLIES 3
v-jefferni
Community Support
Community Support

Hi @VFPowerAppsUser ,

 

You can edit a thread instead of posting a duplicate. Link to the other same thread:

Verification of complex column types in Gallery an... - Power Platform Community (microsoft.com)

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

WarrenBelz
Super User
Super User

Hi @VFPowerAppsUser ,

Using the column you posted, try this structure

If(
   ThisItem.ERHSCutDownVersion.Value = Blank(),
   If(
      Or(
         "3 - Documentation" in ThisItem.Status.Value,
         "4 - PQQ evaluation finished" in ThisItem.Status.Value,
         "5 - Bids evaluation finished" in ThisItem.Status.Value,
         "6 - Closed" in ThisItem.Status.Value
      ),
      Coral,
      Transparent
   ),
   Transparent
)

 

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.

Visit my blog Practical Power Apps

VFPowerAppsUser
Frequent Visitor

Not sure what happened why this is posted twice. Sorry for this. Can I delete a post? Can't find the relevant button.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,718)