Display number of items (MHE) not recorded on today's date

[caliginous1998]

Hi all!

I am fairly new to power app, appreciate any of your help on this! I have a sharepoint list of 3 MHE (MHE 1, MHE 2, MHE 3) that needs to be check every day. 

Based on the screenshot above as an example, how do I display on my power app using the label function to automatically show my user that there is 1 vehicle not being checked for for every single day? (Example shown below):

Thank you!

[v-xiaochen-msft]

Hi @caliginous1998 ,

Here is the sample:

"No of MHE unchecked: "& CountRows(Filter(ListName,Add the condition here))

Best Regards,

Wearsky

[caliginous1998]

Thanks @v-xiaochen-msft ! How do I program the filter in such a way that everyday it will read the Sharepoint list so that every single day it will show which MHE on that day is not checked?

[v-xiaochen-msft]

Hi @caliginous1998 ,

Sorry, I'm confused. How to tell whether a record is checked or not?

Best Regards,

Wearsky

[caliginous1998]

Hi @v-xiaochen-msft , sorry for the confusion! My power app has a form for user to indicate whether they have checked the MHE every single day which will be capture and save in the sharepoint list.  So based on the example below, MHE 3 has not been checked. How do I program it dynamically so that every day it will loop the sharepoint list to check which MHE has not been checked and display it on power app?

Example

Thanks!

[v-xiaochen-msft · Accepted solution]

Hi @caliginous1998 ,

I made a sample for you.

"No of MHE unchecked: "&If(Not("MHE 1" in Concat(Filter(LIST50,Date=Today()),MHE.Value)),"MHE 1",Not("MHE 2" in Concat(Filter(LIST50,Date=Today()),MHE.Value)),"MHE 2",Not("MHE 3" in Concat(Filter(LIST50,Date=Today()),MHE.Value)),"MHE 3")

Best Regards,

Wearsky

[caliginous1998]

Hi @v-xiaochen-msft ,

It worked, thank you so much!