Suppose I have an Excel sheet containing names of all the tenants of an apartment building, payment due date, payment date, payment status, and number of days overdue. So I have the following fields in my Excel sheet:
FullName, Payment Due Date, Payment Date, Payment Status, Days Overdue
I am trying to show in PowerApp the total number of people who have not yet paid their rent . The following is what I have tried but it is not working.
CountIf(Filter(ExcelTable, ExcelTable.'Payment Status' = 'Unpaid'))
Solved! Go to Solution.
I believe the issue is you don't need the "filter" in your function. Try this instead:
CountIf(ExcelTable, ExcelTable.'Payment Status' = 'Unpaid')
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications