Announcements
Hi,
I need to search My browsing screen by both Title and from & To 'date' at the same time
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.
Please Explain
Title="" && from="" && date=DateValue(...)
as iam new to power app
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.
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
no problem the syntax will be the same just change the search parameter of the filter function
right now iam using this
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
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 494
WarrenBelz 352 Most Valuable Professional
11manish 323
