cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tmw900
Regular Visitor

Sharepoint just stuck at Getting your data

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @tmw900 ,

 

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

Snipaste_2020-07-08_10-31-11.png

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

View solution in original post

10 REPLIES 10
WarrenBelz
Super User
Super User

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
Community Support
Community Support

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

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.

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,

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

Hi @tmw900 ,

 

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

Snipaste_2020-07-08_10-31-11.png

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

Hi @v-siky-msft,

 

That worked!  Thank you very much.

 

Tom

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

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,575)