Hi folks,
I have a canvas app which works locally when searching a collection and yet fails to find the same data using the published version. The SQL data sources are identical and I understand the delegation (or at least I think I do!) limits me to 2000 rows per lookup (default up from 500). I have just under 6000 rows so, in sql I have created specific views which return rows 0-2000, 2001-4000, 4001-6000 of a table. I then create a collection in the canvas app using those data sources as below and then my Filtering uses that colEsrStaff collection.
Really baffled as to why it works in edit mode but not in published - ideas anyone?
Screen onVisible:
Solved! Go to Solution.
Hi Catherine,
That does look exactly the same I agree.
If I set the collection to any of the 3 in turn, it works. So it has to be something to do with expanding/adding to the collection, maybe..
Hi @tddeacon
Is this the 1st screen in your app? If so, have you tried placing this code in the app's OnStart property? And when you play the published app, does your collection have any data in it or is it blank?
---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.
Thanks!
Hardit Bhatia
Microsoft Business Applications MVP
Blog | Twitter | LinkedIn | Facebook | YouTube | Email
I had a similar scenario as you do. In my case, I need to lookup all cities by country/state in the world which over 20000 in some Dropdowns, the formulas in OnVisible to get all data is like this:
ClearCollect(WorldCitiesAll, WorldCities);
Collect(WorldCitiesAll,WorldCities2)
And the datasource of cities is Excel file. It works fine in Edit mode and published mode. You can try set the Items of gallery just "colEsrStaff" to check if works fine in edit and published, if it is, then add formulas one by one to check which one is the block.
Hi Hardit,
Yes I did try having the code in the App start up but moved it to the search screen which is not the first screen. The data appears correctly for only the first part of the collection - it seems adding to the collection does not work in published. If I set the collection to any of the 3 in turn, it works. So it has to be something to do with expanding/adding to the collection, maybe..
Hi Catherine,
That does look exactly the same I agree.
If I set the collection to any of the 3 in turn, it works. So it has to be something to do with expanding/adding to the collection, maybe..
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
200 | |
99 | |
59 | |
58 | |
54 |
User | Count |
---|---|
257 | |
161 | |
88 | |
79 | |
69 |