I have a gallery and I want to search by Itemno which is number field in SP of the gallery, can I put in the input box to search as
Filter(list, Value( itemno, serachbox.Text))
Does not seem right. Please advise
Please consider changing your Formula to the following:
Filter(list, itemno = Value(serachbox.Text))
I hope this is helpful for you.
Hi @bbsin ,
Although @RandyHayes has given correct expression.
I'll just add something.
Example you have Item Number 1,2,3....11,12.. etc
Try to filter Gallery Items with StartWith condition like Filter(SampleColors, StartsWith(Text(ID), TextInput2.Text))
This will improve your search results rather than typing completely (example by picture below)
What is itemno then? I assumed this was a column in your list?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.