Power Platform Community Forum Thread Details

Hi Experts,

I have the below code in a text label to calculate all entries logged with certain criteria.

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

In my sharepoint list, the Title column shows the date and time a user creates an entry in the sharepoint list (see below)

Is there a way that I can adapt my code at the top so that I can filter to show the total results during a time period either a day, a week, a month etc. My thoughts are to have a start date choice and an end date choice so that the code filters based on the criteria between those 2 dates?

Thanks in advance!

Categories:

Building Power Apps