cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Weird inconsistency between the editor and the player

Hi,

In my online store's backoffice project, I'm using a gallery to display how much time a specific item was wished by customers.

 

The data is stored in a MSSQL DB and the implementation is as follow:

 

The datasource

gallery_items_func.PNG

 

The wished x times label

gallery_item_count_func.PNG

 

Now, this is working fine in the PowerApps editor. It looks like this:

editor.PNG

Works like a charm !

 

Now, if I publish and play my project, here's the result

player.PNG

Uh oh, that's weird now...

 

So I've went debugging a little, and here's what I found. The XHR requests made to the MSSQL API are slightly different in the player and the editor.

 

Here's the XHR request in the editor:

request_editor.PNG

request_response_edior.PNG

 

And here's the request in the player:

request_player.PNGrequest_player_response.PNG

 

As you can see, the player is only requesting for the IDs while the editor request the whole data. I believe this is what is causing my issue.

 

Is there some kind of optimization running in player only that could lead to that behavior ?

 

How do I avoid this ?

 

Regards,

Guillaume

1 REPLY 1
Highlighted
Power Apps
Power Apps

Re: Weird inconsistency between the editor and the player

@Guillaume_V Group By function has known issue with "Explicit Column Selection" advance feature, you can either turn off that feature and republish app or explicitly mention columns required after formula.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (6,603)