Answered

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

(0) Share

Report

Posted on by 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.

Screenshot 2024-01-08 095228.png

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):

Screenshot 2024-01-08 100447.png

Thank you!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @caliginous1998 ,

Here is the sample:

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

Best Regards,

Wearsky
caliginous1998 12 on at

Like
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @caliginous1998 ,

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

Best Regards,

Wearsky
caliginous1998 12 on at

Like
a
(0)

Report
Copy link

Link copied!

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!
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft ,

It worked, thank you so much!