web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Need help with a compl...
Power Apps
Unanswered

Need help with a complicated filter

(0) ShareShare
ReportReport
Posted on by 39

Ok, this is where I turn when I'm stumped, and I'm really stumped right now.

 

The workflow is end users schedule pickups on Wednesdays and Fridays and they only schedule up to 15 items on those days. SO I wanted a way for the end user to be able to filter with a date picker but I also want them to be able to see all the records so they can search for an address if there was an issue. This is where my problem is.

 

I have a list called Bulk Item Pick Up, a date picker called dteSearch, and a radio button that enables the filter called rdoDateSelect.  The gallery items property is If(rdoDateSelect.Selected.Value="Filter Date", Filter('Bulk Item Pick Up', Date>=dteSearch.SelectedDate,Date <DateAdd(dteSearch.SelectedDate,1,Days)),'Bulk Item Pick Up') Basically, if the Filter dates button is selected show the items that correspond to the date picker, else show the entire list. I have a text input called TextInput1_3 and I would like to add a search to this formula where if Show all dates is selected then they are able to search the address field.

 

Thanks for your help. 

bulky item no filter.jpg
bulky item filter.jpg
Categories:
  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @bm94 ,

     

    Please try:

    If(
     rdoDateSelect.Selected.Value="Filter Date", 
     Filter(
     'Bulk Item Pick Up', 
     Date>=dteSearch.SelectedDate,
     Date <DateAdd(dteSearch.SelectedDate,1,Days)
     ),
     Search('Bulk Item Pick Up',TextInput1_3.Text,"SearchColumn")
    )

     

    Best Regards,

    Bof

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 354 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 320

#3
Mohsin Ali Profile Picture

Mohsin Ali 246

Last 30 days Overall leaderboard