
Announcements
Hey Guys,
I'm currently working on an app with an SQL Database. My function on the Item property of my Gallery is:
Copilot suggests that there are several errors in the expression:
I've double-checked it and believe it should be correct. Am I missing something? Are there specific considerations I need to be aware of because I'm using an SQL Database and not a SharePoint list?
Thanks for your help!
Hi @SimonP2
The correct syntax is to not include double quotes around the column names:
Search(Vorgang, txtSearch.Text, Beschwerde, Eingang, Grund, Vorgangsnummer)
If you're running the Power Apps editor in German, you'll need to replace the commas with semi-colons.
Search(Vorgang; txtSearch.Text; Beschwerde; Eingang; Grund; Vorgangsnummer)
Hopefully one of the 2 above will resolve the issue.