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, I am having the same problem and I tried the below solutions but didn't work.
My first problem was not seeing the Form1 when I run the application.
I saw two ways to resolve this problem:
1. Change Default Mode from Edit to New
2. Or add First('Test Sample list') into Item when the Default Mode is Edit
both work fine. However, in both versions, if I reach the app via the link I see Getting your data message.
I tried to add ResetForm(Form1); RequestHide() but it didn't work. I tried to add what Sheldor suggested.
If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('insert data source name'),SharePointIntegration.Selected)
But I am getting an error for SharePointIntegration because I think I didn’t use it.
What I did is, I created a list in SharePoint (5-6 columns, empty data) and then I connected this to PowerApps.
My aim is only to submit new data to this list.
How can I overcome this problem? Yes I have experienced the same issue multiple times.
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
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.
- In your "Tree View" (left side of your screen) select the Form then at your screen right side in th "Default Mode" select "New".
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.
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 :)
I am also facing the same issue when using the Power App within Power BI. This issue seems to occurring with Sharepoint List. When trialing the input in App the fileds get populated perfectly into SharePoint List however through Power BI is stuck at "Getting your Data".
My Form on Success is as per below
Notify("Hospital Rating updated successfully",NotificationType.Success,2000); Navigate(Screen1); ResetForm('Hospital Rating'); RequestHide()Any suggestions ?I am having a the same issue but my app is set up a little differently, I have a home screen that is just buttons to navigate to different screens. The actual form is a splir of a couple things. A couple custom input fields and a repeating field gallery. Due to the requirements, this (and not the edit form) was the only way to do it. Due to this I don't actually have a form control per se. My app gets stuck on getting your data right when I start it. Any ideas?
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?
Deleted
Have you managed to find the cause of the issue? We have the same behaviour with one of our PowerApps.
Thanks.
Maria
Please check the Item property from your Form.
I have entered the following selection ('OrderForm MCPD_1' is the SP datasource):
- this works for me with Excel tables.
*ID = table column name
If( IsBlank(
LookUp('table_RequestData', ID <> "")
),
First(table_RequestData),
LookUp('table_RequestData', ID <> "")
) 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.
