Forum Discussion
PowerApp forms get stuck on "Getting your data..."
Some, but not all of my SharePoint Forms that are built using PowerApps are getting stuck saying (Getting your data...". The strange thing is that sometimes the data will load then this will happen, or I can click out of the form and reopen it and then it will work. Anyone experiencing a similar issue?
Hi guys,
I too was having the same issue but resolved it by:
1. Changing the form name in the Tree view to the left to its default value, which is SharePointForm1.
2. by adding
ResetForm(CreateItemForm); RequestHide()
to the OnSuccess field as Ryan Robinson suggested but obviously added my Form name instead of using "CreateItemForm", so my string looked something like this ResetForm(SharePointForm1); RequestHide()
3. I also added:
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('insert data source name'),SharePointIntegration.Selected)
to the Item field in the same advanced properties menu for the problematic form as the field was blank for me for some reason.
I hope this works for somebody else as well :)
Thanks!Sheldor
This solved my problem.
Erin Napier , you are most welcome!
Glad I could be of assistance :D
- I only had to do steps 2 & 3, but that fixed my issue too - thanks Sheldor!
StaceyLaney You are most welcome 😄
I was also stuck on this and just figured it out as I was in the process of writing a post here, so I'll explain it for the sake of anybody else who comes along.
The part that was missing for me was on the CreateItemForm. Click on the problematic screen in the Screens panel on the left, Advanced Properties, and the OnSuccess field. That needs to be:
ResetForm(CreateItemForm); RequestHide()
I guess when I copied from other forms it didn't keep that default, or it otherwise somehow got lost along the way. I kept looking at the SharePoint Integration formulas and wasn't getting anywhere before I eventually stumbled across that.
- After days of googling this is the best answer that worked for me. Thanks! 😉
- It helped
Please check the Item property from your Form.
I have entered the following selection ('OrderForm MCPD_1' is the SP datasource):
This worked for me. Looks like for Custom Edit Form, SharePointIntegration.Selected in blank where as SharePointIntegration.SelectedListItemID has the ID value so we have to first fetch the Item by using your above formula which is:
If(IsBlank(LookUp('Active Proposals', ID = SharePointIntegration.SelectedListItemID)), First('Active Proposals'), LookUp('Active Proposals', ID = SharePointIntegration.SelectedListItemID))
Note that this is only true for 'Custom Edit Forms' and not if you are using a single default Form for both New and Edit cases.
Note: Specify your own data source (SP List name) here instead of 'Active Proposal' in above formula.
- this works for me with Excel tables.
*ID = table column name
If( IsBlank(
LookUp('table_RequestData', ID <> "")
),
First(table_RequestData),
LookUp('table_RequestData', ID <> "")
)
If it's an Edit form, make sure it has a record stipulated in the Items property - otherwise it tends to show up as a blank form when you run the app. You need to tell it to start at the first field or it gets lost in BFE. I tried many crazy suggestions for a couple of hours and this one finally worked and actually made sense. The Item's property for an Edit form is usually linked to a gallery selection somewhere else, but I'd need some more info to determine if this is the case for this app - for now set it to
First(yourSourceName)
where yourSourceName is your SharePoint list connection - if that doesn't work I'll need some more info
Just came across this page while searching similar problem but in New Form. If always stuck in "getting your data" or "No Item to Display", select the Form and in Properties make select Default Mode as New.
I simply switched the Default mode of the form to new, i had it set to edit as modified the form to custom after the initial data connection. This fixed the issue for me.
I personal like to add the form attributes separately so i can position them without the constraints of then within the form section, but this does lead to issues when you start adding the verification later on in the build as many of the validation features are embedded within the form attribute.
Yes. I am seeing the same problem. I rebuilt the app with no success.
If you found a fix, please do share. Thanks in advance.
Thank you so much. I can confirm that that fixed the issue. I added a couple of functions to refresh data source and calling NewForm for OnSelect. Much appreciated for the pointers!
Refresh(DataSource);NewForm(Form);Navigate(ScreenView,ScreenTransition.Fade)
Deleted
Have you managed to find the cause of the issue? We have the same behaviour with one of our PowerApps.
Thanks.
Maria
I'm experiencing the same issue, "Getting your data..." after submitting a form. OnSuccess I put the Navigate(SuccessScreen), but it is not navigating to success screen just displaying "Getting your data...". Although SharePoint list has been updated successfully. Is this bug in Powerapps or am I missing any configuration?
- In your "Tree View" (left side of your screen) select the Form then at your screen right side in th "Default Mode" select "New".
Hi
from the other comments about re-ordering the functions on the form I thought the form should be reset at the start, so that's what I did.
Select App (top of left Pane)
Set property 'OnStart' to Reset(Formname)
It worked a treat!
But I never would have got there on my own, so thanks Alan Chai
