Announcements
Hello, If I scan the same barcode again it should show the error message so I used this formula but it doesn't work.Can anyone help with this??
Hi,
The issue is StartsWith requires two arguments and you've only given one. If you want to look up values where AssetSN Starts With LabelSN_7.Text try this instead. StartsWith( AssetSN, LabelSN_7.Text )
Hi..Thank @Sickle-Cell for your reply. As you said I used that formula, But that also showed a delegation warning error.
Hi @Anandhavalli,
As far as I know there isn't a way to remove the delegation warning for this example as CountRows isn't a delegatable function. It can, however, be safely ignored so long as the data you are returning doesn't hit the delegation limit. One way to do this is by swapping the CountRows to outside of the Filter function then ensuring that the filter only ever returns less than 2000 records.One option you do have that should remove the delegation warning is by taking the data into a collection and running the function exactly as you have it, but using the collection as opposed to the data source. The downside to this is that if you are patching information to a server and want it to update quickly, you need to either also patch to the collection.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 396 Super User 2026 Season 2
Mohsin Ali 323
WarrenBelz 193 Most Valuable Professional
