Conditionally show images based on Text column

(0) Share

Report

Posted on by aharsh

116

Hi,

I'm not sure if what I'm trying to do will work.

I'm creating a gallery based on a sharepoint list. I have 4 images saved in media and I'd like to conditionally set which image is displayed based on a text field in my sharepoint list.

This is what I tried just to toggle between 2 of the 4 colors, but it's looking for a boolean.

If(nDirectorate = "OD",CONTENTbox_blue,CONTENTbox_yellow)

Is there a way around this? I'm basically trying to color code my results based on which directorate the employee is associated with.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @aharsh

Can you share more details about the app configuration? Where is this nDirectorate coming from?

The expression seems to be right if nDirectorate is a variable storing the appropriate value. If you could share more details, we might be able to help you better. I am assuming that you have placed the expression on the Image property of the control.

Also, are you getting any errors?

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
aharsh 116 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi, @yashag2255 thank you for taking time to respond. Not sure what other details will help.

I have a sharepoint list and I've created a Powerapps gallery that links to it.

One of my columns is nDirectorate, which is a choice column. The 4 choices are - OD, HRD, FMD, AQD.

I've uploaded 4 images to media, CONTENTbox_purple, CONTENTbox_blue, CONTENTbox_teal, CONTENTbox_yellow

I set this code in the Image control for the Gallery, and I'm getting an error. I get a red line under the = and it says invalid argument type.

If(nDirectorate = "OD",CONTENTbox_blue,CONTENTbox_yellow)

Please let me know if those details help and what other details I may provide.

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @aharsh

Since the column is a choice type column, the formula should be:

If(nDirectorate.Value = "OD",CONTENTbox_blue,CONTENTbox_yellow)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
aharsh 116 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, @yashag2255 - Now I'm seeing both blue and yellow boxes - Hooray! That was the first step of my work

Now, I just need to figure out how to show the other two colors based on the other two choices 😕

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@aharsh

To add multiple conditions, you can use the expression as:

If(nDirectorate.Value = "OD",CONTENTbox_blue,nDirectorate.Value = "Value2",CONTENTbox_yellow,nDirectorate.Value = "Value3",CONTENTbox_green,CONTENTbox_red)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No