Hi @StalinPonnusamy ,
So I removed and added the SharePoint list but still the same issue.
So I tested by duplicating the Form and when viewed from this Form I have no issues when connected to the Production SP List.
I think I found the issue. So I have done many changes to my App and for Testing I created duplicate Forms and SP lists of Production recently.
The Test SP list is duplicate of the production SP list. So when I connect the Gallery to Test SP List, it is asking to correct a column. This column name it is trying to use is an old name of the production SP list. I think this is the issue. Why is Power App still referring to an OLD column name. This column was renamed on Production SP List. The most bizarre things is that this is a duplicate SP list, so it shouldn't ask for it when I connected the Test SP List.
So with more testing I find that I STILL get the msg ""Getting your Data.." and then it is loading the data if I connect without changing the gallery to the old name but after I do that I have no issue with the Duplicate Form. Meaning first connect the gallery to test SP List and change the name and then connect to Production SP and I don't get the msg ""Getting your Data.." while loading.
Anyway it has corrupt the original Form. Even I connect it to Test SP List I'm getting the error ""Getting your Data.." and then nothing.
Maybe I'm wrong . Can I get your input on this since I cannot delete the original Forms. It will be lots of work creating duplicate and renaming the Datacard since they are referred elsewhere.
What might I try to correct the original form?
Any help from you guys too @RandyHayes @WarrenBelz @zmansuri
Thanks