You’re offline. This is a read only version of the page.
211
Good Day,
Can anyone offer a solution as to how to format the Text Search Box to Search for Street Name, House Number and/or Work Order Number?
Thank you!
Hi @Shaguar357,
Have you solved your problem?
I suggest you use the SortByColumns():
Share
Report
All responses (
Answers (
SortByColumns(DailyWorksheet,"Street",SortOrder.Descending)Good Afternoon @zuurg
I apologize for just getting back with you. I made the changes you suggested and it seems to be getting closer or at least there are less errors showing up:
Any idea how to get the data to show in the app now?
Thanks again for your help!
Try using the code below, this will prompt delegation warning, I suggest you store your data source in a collection to prevent/remove delegation warnings, but overall this should work.
Filter(
Sort(DailyWorksheet,'Date Installed',SortOrder.Descending),
Or(
searchTextInput.Text in 'Street Name',
searchTextInput.Text in Text('House Number')//Converted House Number to Text(),
searchTextInput.Text in Text('Work Order Number')//Converted Work Order Number to Text()
)
)
Actual Result
Just typing Date Installed as the column name won't work. I think it has to be enclosed in double quotes, and if there's a space in the column name, you might have to convert that space to _x0020_. Also, if you're searching for a date and the Date Installed column is a DateTime type, you're going to need to convert what you're searching for to a DateTime type.
I suggest maybe starting with a Text column type to see how it should be working.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
