My app is linked to a SharePoint list.
I have a gallery which show registration plates (see attached file) and I want to put a label which shows the number of values of a colum that meet these requirements:
1. The registration number is the same that appears in the gallery
2. The value is blank
I've tried the folowing:
CountIf(MySharePointList, Registration=ThisItem.Registration && Colum1=Blank())
The condition for the 1st requirement does not work. Can someone help me with this?
Go to Solution.
Set(totalCount, CountRows(Filter(MySharePointList, filtercriteria))
totalCount gives the count based on the filter criteria.
Hope this helps.
View solution in original post
Many Thanks! @shailendra74
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand