cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BluRonnie
Level: Powered On

Issue with gallery control getting Orders list from Dynamics

I am building this app to retrieve the project type orders from Dynamics and let the users add new lines and etc. It was working OK in PowerApp release 3.19064.11 and for some reason, it stopped working in both 3.19064.13 and the current version 3.19071.14.

The symptom is: The gallery retrieves no records from Dynamics, but if I remove the data source (Dynamics 365 > Orders) and added it again, it will retrieve the information correctly, but when I try to refresh or save/close/open the app again, the issue comes back. Initially, I thought it may be related to the formula, variable and etc. but the same problem happens even when I just add a new gallery and link it to Orders without any customisation.

However, if I start a new App and add the Orders as a gallery, everything works. 

 

I'm not sure why this happens and if this is related to the new release of PowerApps or maybe Dynamics (as we did notice an issue with Dynamics not displaying project line form properly)

Screenshot - 12_07_2019 , 12_16_09.png

1 ACCEPTED SOLUTION

Accepted Solutions
BluRonnie
Level: Powered On

Re: Issue with gallery control getting Orders list from Dynamics

I have done some changes which seem resolved the issue:

 

  • The gallery was using a collection as part of Items and I have changed it to Orders. SortByColumns(Search(Orders,txtProjectContractSearch.Text,"name"),"name",Ascending)
  • There is a global variable for saving the record of the order selected/created which it is needed for other screens. hence there is a Set clause on the gallery OnSelect to save the selected record from the gallery and also another Set clause on the OnSelect of a "Save" button on the Order Detail screen to save the new record created. I think it could be the 2nd set clause was not done properly which causing the system confused about the definition. 

Once I have done above two changes, the gallery behaves correctly. 

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Issue with gallery control getting Orders list from Dynamics

Hi @BluRonnie 

 

Could you please consider turn off the "Improved app rendering (final validation)" option within Advanced settings of App settings of your app, then re-load your app, check if the issue still exists?

Could you please change browsers to test?

 

Best Regards.

Yumia

BluRonnie
Level: Powered On

Re: Issue with gallery control getting Orders list from Dynamics

Thanks @v-yuxima-msft  for the reply.

 

I have just tried to turn off the settings and used the different browser (ie, I was using Chrome) but they didn't help. 

BluRonnie
Level: Powered On

Re: Issue with gallery control getting Orders list from Dynamics

I have done some changes which seem resolved the issue:

 

  • The gallery was using a collection as part of Items and I have changed it to Orders. SortByColumns(Search(Orders,txtProjectContractSearch.Text,"name"),"name",Ascending)
  • There is a global variable for saving the record of the order selected/created which it is needed for other screens. hence there is a Set clause on the gallery OnSelect to save the selected record from the gallery and also another Set clause on the OnSelect of a "Save" button on the Order Detail screen to save the new record created. I think it could be the 2nd set clause was not done properly which causing the system confused about the definition. 

Once I have done above two changes, the gallery behaves correctly. 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 100 members 5,359 guests
Please welcome our newest community members: