Sharepoint just stuck at Getting your data

[tmw900]

I have created a form using a Sharepoint list.  When I click into the form in SP, it just hangs up at Getting your data.  

I've tried the following steps:

  1) My OnSuccess value is ResetForm(SharePointForm1); RequestHide()

  2) I switched the form default property from Edit to New.  

  3) I tried to add If(IsBlank(LookUp('Intake Form', ID = SharePointIntegration.SelectedListItemID)), First('Intake Form'), LookUp('Intake Form', ID = SharePointIntegration.SelectedListItemID)) to the Item value but receive the following message.  "Delegation warning.  The highlighted part of this formula might not work correctly on large data sets. "First" operation is not supported by this connector."

Please help.

[WarrenBelz]

Hi @tmw900 ,

The OnSuccess should not matter as it only triggers after a form is submitted

Put the default to Edit or View - the built-in controls (OnView, OnEdit, OnNew) will take care of all of that.

With the Delegation error, put the Form Item to

SharePointIntegration.Selected

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[v-siky-msft]

Hi @tmw900 ,

The issue is caused by Items property of Form.

What is 'Intake Form'? Is it the form you are editing and customizing?

If so, please modify the code as follows.

If(IsBlank(SharePointIntegration.Selected)|| IsEmpty(SharePointIntegration.Selected), First([@'Intake Form']),SharePointIntegration.Selected)

Hope this helps.

Sik

[WarrenBelz]

Thanks @v-siky-msft ,

I actually had a delegation error yesterday on that standard code and needed to change it to what I posted. It should not happen I know, but it did and I have seen a couple of other posts with the same issue.

[tmw900]

Hi @WarrenBelz,

Thank you for your reply.  I made your suggested changes and it still hangs up with the 'Getting your data'.

One thing to note, my labels will display on the Getting your data screen but none of the form fields.  Any other thoughts?

Thanks,

[tmw900]

Hi @v-siky-msft,

Intake Form is the name of my datasource.   I added the code you provided in the Item field and I still get the same Delegation warning.  My form name is SharePointForm1.  Does the order in the tree view matter?  I have SharePointForm1 at the top and then labels and buttons below.

Tom

[v-siky-msft · Accepted solution]

Hi @tmw900 ,

I have tried, but I can't reproduce your issue, there is no delegation warning in Items property.

Here is an alternative workaround, try to modify the Items property as follows.

LookUp(postcode,ID=SharePointIntegration.SelectedListItemID)

If it still shows "Getting your data", please consider deleting the powerapps form in List Setting - Form Setting - Delete custom form, and then re-create one to see if the warning is gone.

Hope this helps.

Sik

[tmw900]

Hi @v-siky-msft,

That worked!  Thank you very much.

Tom

[KevinColeMCM]

Deleting  your form and recreating it is a poor solution.  Especially when it takes 8 hours to make the dang form.

[darrellwinston]

Exactly.  It takes forever because of the STUPID User Interface design.  I have NEVER seen an IDE change Properties on another Control, because I am editing a separate Control.  So deleting the the Form is a Terrible solution...but the way this application is made, I wouldn't be surprised if that is the only solution... Sorry about my venting here.