Power Platform Community Forum Thread Details

Hi Experts,

I have the below formula to calculate number of tickets based on the selection of various dropdowns, this is limited to 2,000 entries, can you advise how I can calculate the entire sharepoint list without limitations please?

CountRows(
Filter(QualityPortal, 
'Business Unit' = 'Dropdown-BusinessUnit_2'.Selected.Value || "Please select an option"=('Dropdown-BusinessUnit_2'.Selected.Value),

Classification = 'Dropdown-Classification_2'.Selected.Value || "Please select an option"=('Dropdown-Classification_2'.Selected.Value),

Status = 'Dropdown-Status_2'.Selected.Value || "Please select an option"=('Dropdown-Status_2'.Selected.Value),

Function ='Dropdown-SourceFunction_2'.Selected.Result || "Please select an option"=('Dropdown-SourceFunction_2'.Selected.Result),

'Cause Category' = 'Dropdown-CauseCategory_2'.Selected.Title || "Please select an option"=('Dropdown-CauseCategory_2'.Selected.Title),

Source = 'Dropdown-Source_2'.Selected.Value || "Please select an option"=('Dropdown-Source_2'.Selected.Value),

'Business Change Required' = 'Dropdown-BusinessChange_2'.Selected.Value || "Please select an option"=('Dropdown-BusinessChange_2'.Selected.Value)
)
)

Thanks in advance!

Categories:

General Questions

Connecting to Data

Using Apps Using Formulas