Answered

Yet another Getting your data ... issue

(0) Share

Report

Posted on by BenDonahue

932

I have a survey app created that asks questions that will be recorded in a SharePoint list. For 21 of 25 pages (many pages have just one question), everything works fine. F or those last three pages, the question is not populating on the app page, instead displaying, "Getting your data ..." endlessly. Using the same connector, accessing the same list, I am unable to see how this is getting a different result as the other successful pages.

I can't tell the difference between the pages that work and the pages that do not, except for the column being referenced to save the responses to.

I even added that same question to a working page, and referencing the same column as the non-working page did not break the working page.

I have re-created this page twice from scratch, and still am not able to root out the issue.

Your help is appreciated; l thank you.

P.S. Regarding adding question to a page that already works, I tried to duplicate that page, rename it to the old name, Page6, save and version update, and Page 6 does not work again. I renamed the page to PageSix, and it works. I have a workaround that seems to be working, but not a solution: Why does Power Apps not like "Page6" but does like "Page5" and "PageSix" for a title and why does that effect the connector?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @BenDonahue ,

Could you please share more details about your App? Is it generated from SharePoint list Customize form or an individual app? Are those forms all Edit Forms in New Mode? What formulas have you applied on the Next and Back buttons? What are in those Forms' Item property, Gallery.Selected?

As per you mentioned in the post, I think those last forms may lost connection with data source. Assuming the Next Button with the formula Navigate(NextScreen), please try:

Modify the formula in OnSelect of Next button to NewForm(NextScreenForm);Refresh(ListDataSource);ResetForm(NextScreenForm); Navigate(NextScreen)

If the issue persists, please share the details on the questions above.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
BenDonahue 932 on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni
This may prove to be a simpler situation that will reveal the core of the issue. I created a mini version of the one described earlier that is extremely simple. One page, same connector, one button, one form with three fields.
Button OnSelect function:
Patch(
['Household Interaction Data'], Defaults(['Household Interaction Data']), {StreetAddress: DataCardValue2, StreetAddress2: DataCardValue3, DoorAnswer:DataCardValue7}
)

After saving (no versioning update on first save, of course):
Pressing "play" at the top of the screen:

Running the app:

This is confounding and frustrating.
This is supposed to be a simple use-case so I can test IF I can add data to a SharePoint list, not IF I can make a form appear on a PowerApps page.
What am I doing wrong?

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @BenDonahue ,

Could you share the Item property of that Form? Is it something like Gallery.Selected?

Here in your demo, I think the form’s Default Mode is NewMode, and when you navigate in the screen it’s also in New Mode which means NO item in it, after your Patch action, it would submit a record to the data source but then the form could not know what data to get thus occurs the Getting data issue.

Basically in the form’s OnSuccess is the function of Back(), so if from view form to edit form, back to view form page and if add new item on gallery page to edit form, back to gallery page.

On your side, you could try to Refresh the data source and EditForm/ViewForm to force the form to be Edit/View Mode if you would not like to navigate away, but the point is to leverage the Item property to tell the form which item to display, such as “Form1.LastSubmit” or some specific record you may use LookUp function to retrieve.

Hope this helps.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No