Changing color based on data exist or not in sharepoint list

(0) Share

Report

Posted on by Mahesh005

Hi I have a sharepoint list as mentioned below

In Power apps i have Cell id combox and a button as below

my scenario is to change button color as yellow when if there is a date in Actual start date i.e. not empty.

Any help is appreciated.

Thanks

Mahes

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report

Re: Changing color based on data exist or not in sharepoint list

Hi @Mahesh005 ,

Is the Combo box and Button on a Form control?

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Mahesh005 36 on at

Like (0)

Report

Re: Changing color based on data exist or not in sharepoint list

hi @Amik ,
no. it's just a individual button and a individual combo box. i just need color changing logic either it can be button or a lable.

Thanks,
Mahesh

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (1)

Report

Re: Changing color based on data exist or not in sharepoint list

In the button's fill, you could use IsBlank(YourComboBox.Selected.ActualStartDate, Color.Yellow, Color.Blue)

hope this helps!

Was this reply helpful? Yes No
TimmeyNL 7 on at

Like (1)

Report

Re: Changing color based on data exist or not in sharepoint list

Hi @Mahesh005

You can reference the combobox's not visible field in combination with the Fill of the button.

If(Not(IsBlank(combobox.Selected.ActualStartDate)), RGBA(56, 96, 178, 1),RGBA(10,10,10,1))

Was this reply helpful? Yes No
Mahesh005 36 on at

Like (0)

Report

Re: Changing color based on data exist or not in sharepoint list

hi @TimmeyNL , @madlad

I have Cell id in combo box. so Actual start date is not coming
Thanks,
Mahesh

Was this reply helpful? Yes No
Ami K 15,674 Super User 2024 Season 1 on at

Like (1)

Report
Re: Changing color based on data exist or not in sharepoint list

@Mahesh005 - assuming the Items property of your Combo Box is the data source, apply the below to the Fill property of your Button.

If( IsBlank( LookUp( 'Your Data', Title = Your_ComboBox.Selected.Title', 'Actual Date' ) ), Color.Yellow, Color.Blue )

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
Mahesh005 36 on at

Like (0)

Report

Re: Changing color based on data exist or not in sharepoint list

Hi,

I have Combobox values as follows

Was this reply helpful? Yes No
TimmeyNL 7 on at

Like (0)

Report

Re: Changing color based on data exist or not in sharepoint list

@Mahesh005

What do you have as source for your items?
It should be a reference to your sharepoint list, datatype table (in this case, my list is called Client):

Was this reply helpful? Yes No