Filter Using Dates and Conditional Formatting in Specific Columns

[Anonymous33]

Hi Everyone, 

I would like to consult the following: 

1. How to filter using dates. The other filters have been working and fixed (with the help of the PowerApp community). I wanted to add another filter (date filter). Please see formula below: 

SortByColumns(

   Search(

      AddColumns(

         Filter(

            'Customer Forms Masterfile',

            Len(cbHBPRepFilter.Selected.Value) = 0 || 'HBP Rep' in cbHBPRepFilter.SelectedItems,

            Len(cbStatusFilter.Selected.Value) = 0 || 'Status' in cbStatusFilter.SelectedItems

            'Date Received' >= DatePicker1.SelectedDate && 'Date Received' <= DatePicker1_1.SelectedDate

         ),

         "ProjectID",

         'Project_x0020_ID'.Value

      ),

      TextInput1.Text,

      "ProjectID"

   ),

   "DateReceived",

   SortOrder.Descending

)

2. I would like to add a conditional formatting - where all of those columns that have blank/no data will highlight in red, while those who already have data will remain as is/no color. (This is just to inform the user that there are blank data they have inputted and need to fill out once they have the complete data). I saw in some of the youtube videos that they are editing in the Fill instead of the Items. I would like to consult and ask what is the correct formula for this one. (Please see existing formula)



Thank you in advance! 

[Amik · Accepted solution]

@Anonymous33 - 

1. Apart from missing a comma, I am not seeing anything wrong with your code.

2. You can modify the Fill property of the Label control embedded inside the Gallery. E.g.:

 If( Len(Self.Text) = 0, Color.Red, Color.Transparent ) 

[Anonymous33]

Thank you very much Amik! Will try this 🙂 

[Anonymous33]

Hi, 

I tried the the formula

1. It's still indicating with errors. Please see picture below. It's not identifying the  'Date Received' >= DatePicker1.SelectedDate (there's no selected date in the dropdown) 

2. I colored the whole form with black. Is there other way just to highlight specific columns that are blank with red and rest with what is the existing color of the form? 

Thank you very much for the help! 

[Amik · Accepted solution]

@Anonymous33 - 

1. Please review the image I sent again. The comma should be on the second row.

2. That is exactly what the suggested solution I already provided does. I suspect you have done something else.

[Anonymous33]

Sorry! My bad for number 1. It's now working. 

I'll try again for number 2. 

[Anonymous33]

Sorry to bother.

Tried the number 2. But how to retain that the color instead of transparent - it would be specific color? like this  RGBA(253, 222, 207, 0.41) or FDDECF? 

[Amik]

@Anonymous33 - I am no longer clear on what you're trying to do.

As I understand it, suppose our Gallery control has a fill colour of blue, and you embed a Label control into that Gallery.

If the Text property of the Label returns blank, then the Fill property of the Label should be Red.

If the Text property of the Label does not return blank, then the Fill property should be transparent (and therefore display the colour of the Gallery (blue).

Is this not what you want to do?

[Anonymous33]

Yes correct. That's what im trying to do. But apologies, I will need to review what I did. Thanks! 

[Amik]

@Anonymous33 - please share the code you have used on the Fill property of your Label control.