I am setting up an app that works fine in test-bed but partly fails when I publish and run it as an APP. It actually functions as intended but gives the following error-message every time I load data:
"The requested operation is invalid. Server Response: Table1 failed: Expression "ConsultantName eq null" is not supported. clientRequestId:....." (Long number after clientRequestId:
The data comes out of an Excel formated like a table, all datafields are tight strings, all datafields have been quality checked to the best of my abilities, the table is called Table1.
My app is based on a empty canvas and has a drop down box called Droopdown1 with the following data: Distinct(Table1,Decision)
I have a Gallery called "GalleryScope" setup below the drop down acting on the drop down with the following data: Filter(Table1, Decision = Dropdown1.Selected.Result)
I have a Formviewer on the right displaying various values. It has the following data: GalleryScope.Selected
Finally I have a small Gallery called Gallery 3 (Yeah I know, not a good name) that has the following data: Filter(Table1, ConsultantName = GalleryScope.Selected.ConsultantName). What this does is to pull out all records with the same consultant name.
Now I am fairly new to this game, I started last week. Lots of fun to play with it and I love the platform! That said, I have Googled and watched more Youtube the last week than last year combined.
Still, this one I cannot figure out. I have a vague idea that this could be caused by launch sequence of the app, and that the variable ConsultantName in that launch sequence could be null before fields are refreshed (ie that ConsultantName is a required value somehow). Now I am guessing simply based on what I see other have struggled with. The app actually works as intended but the error messages is poking my eyes every time I use the app. Not to mention that I need to show it to the higher-ups at one point.
Is there anyone out there who has more than one week of experience on this AND is able to point me in the right direction? Any help here would be highly appreciated 🙂
Thanks!
Bjorn
