Hi all 🙂
I'm asking PowerApps to:
Search(Table1,"SW1","Postcode")
✅This works, giving me all the SW1 records.
What I need is for it to return (for example) SW1, SW2 or SW3 - so a bigger list containing any records from a few different postcodes (basically this kind of thing) - it's the bit inside of the stars that I'm struggling to sort out.
Search(Table1, *** "SW1" OR "SW2" OR "SW3" *** ,"Postcode")
... I've tried playing around with OR statements with not much luck.
Any help much appreciated thanks 🙂
Solved! Go to Solution.
The SEARCH function cannot be delegated in SharePoint so you might want to use a different function instead. This will allow you to search Table1 beyond 2,000 records.
I would suggest a combination of FILTER + STARTSWITH instead which can be delegated. It would look something like this.
Filter(
Table1,
StartsWith("SW1","Postcode")
Or StartsWith("SW2","Postcode")
Or StartsWith("SW3","Postcode")
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
The SEARCH function cannot be delegated in SharePoint so you might want to use a different function instead. This will allow you to search Table1 beyond 2,000 records.
I would suggest a combination of FILTER + STARTSWITH instead which can be delegated. It would look something like this.
Filter(
Table1,
StartsWith("SW1","Postcode")
Or StartsWith("SW2","Postcode")
Or StartsWith("SW3","Postcode")
)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Thank you 🙂
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
200 | |
184 | |
69 | |
42 | |
34 |
User | Count |
---|---|
341 | |
266 | |
114 | |
64 | |
64 |