I am seeking help/suggestions with some issues that I am facing my customized list form in PowerApps-
Background- This is a custom list with about 150 odd columns. I am using PowerApps for new, edit and view forms. The form has 2 sections which are visible to seaparate set of users based on their permissions which I am controlling through a flow.
1. 8 out of 10 times when I open the form it shows me the correct section, but then 2 times it does not. However when I close and reopen the form, It fixes the issue. I looked into the flow history and the flow it shows successful execution and no errors there.
2. I have a Save as Draft button on the form, that looks at 1 required field in order to be able to save the form. It was working alright until mid this week. Now when I click on the button it shows that it processing, flickers a little and then nothing happens. This is also very random and works intermittently.
3. I added some new fields to the list and added them to the form, after publishing i realized then most the dropdowns in form had stopped working. I had to refresh the dataconnection a few times to get that back to working. I am not sure why did I have to do that over and over again. This has happened in the past as well and multiple refreshes on the dataconnection resolved the issue.
These are some of the strange behaviors that we are noticing on the form which is making me question the reliability and scalibility limits of PowerApps.
Any ideas/suggestions are welcome.
Best