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

All responses (8)

Answers (0)

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):
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
Ami K 15,656 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.
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
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))
madlad 2,637 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!
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
Ami K 15,656 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.