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 Apps
Unanswered

Date & Time search

(0) ShareShare
ReportReport
Posted on by 29

Hi,

I need to search My browsing screen by both Title and from & To 'date' at the same time

 

Categories:
I have the same question (0)
  • anandm08 Profile Picture
    1,936 Super User 2024 Season 2 on at

    hi @Murshid22 ,

    Filter('table name',Title="" && from="" && date=DateValue(...))

    try this formula.

     

     

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • Murshid22 Profile Picture
    29 on at

    Please Explain 

    Title="" && from="" && date=DateValue(...)

    as iam new to power app

  • anandm08 Profile Picture
    1,936 Super User 2024 Season 2 on at

    replace "" with your search field and from  = "" as well 

    let's suppose I have a list A in this list I have a few columns like title, and from and date and so on

    now I want to filter the data which have title="title1" , from should be "ABC" and date should today date so my filter function will be

    Filter('A',title="title1" && from="abc" && date=Today())

     so this will return the matching row.

  • Murshid22 Profile Picture
    29 on at

    okay i understand now

    But What i wanted is

    i have two datepickers (for fromdate & To date) and a search field 

    I need to use both search filed (Search field based on Title)  and the date pickers for fromdate & To date to filter content from my Browsegallery

  • anandm08 Profile Picture
    1,936 Super User 2024 Season 2 on at

    no problem the syntax will be the same just change the search parameter of the filter function

  • Murshid22 Profile Picture
    29 on at

    right now iam using this

     

    Filter(
        'Goods Entry & Exit',
        StartsWith(
            Title,
            TextSearchBox1.Text
        ) && DateValue('Date & Time IN') >= DateValue(DatePicker1.SelectedDate) && DateValue('Date & Time IN') < DateValue(DatePicker2.SelectedDate) +1
    )
     
    But this have delgation issue
  • anandm08 Profile Picture
    1,936 Super User 2024 Season 2 on at
    Filter(
     'Goods Entry & Exit',
     StartsWith(Title, TextSearchBox1.Text)
     && DateValue('Date & Time IN') >= DatePicker1.SelectedDate
     && DateValue('Date & Time IN') < DateAdd(DatePicker2.SelectedDate, 1, Days) // Use DateAdd for delegation
    )

    try this

     

     

     

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 414

#2
WarrenBelz Profile Picture

WarrenBelz 377 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 315 Super User 2026 Season 1

Last 30 days Overall leaderboard