Distinct and filter SharePoint list based on Date Range in a Dropdown menu

(0) Share

Report

Posted on by Greg68

138

Hello,

I have a dropdown menu that filters a column in a SharePoint list the formula I used works, however I want to add start and end dates columns to this filter, so the Dropdown menu, by default, will show the item that match the current month dates Start and End.

the Formula I used that works:

Distinct(Filter('SharePointList', Cohort = "51"), 'Course Name')

However when I try to add the filter by date start and end, seems I'm missing something, below is the what I'm trying to use:

With(
{
StartDate: Date(
Year(Today()),
Month(Today()),
1
),
EndDate: Date(
Year(Today()),
Month(Today())+1,
1
)-1
},
Distinct(Filter('SharePointList', Cohort = "51"), 'Course Name'),
StartDate >= StartDate,
EndDate <= EndDate
)
)

Any idea please?

Thanks for your support

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

SagarVIS96 212 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Greg68 ,

1. Give it a different name to start and end date which you are creating with "With" function to differentiate between the sharepoint start and end date field.
2. You need to apply filter based on start and end date inside the filter function itself which I have mentioned below.
With( { _startDate: Date( Year(Today()), Month(Today()), 1 ), _endDate: Date( Year(Today()), Month(Today()), 1 ) - 1 }, Distinct( Filter( 'Power Apps Training', DueDate < _startDate, Created > _endDate ), Name ) )
Thanks and regards
soundarya 16 on at

Like
a
(1)

Report
Copy link

Link copied!

Hello Greg68,
Can you refer the link here is the solution for your question https://stackoverflow.com/questions/50005890/powerapps-filtering-drop-down-based-on-datepicker-selection