Answered

Getting your data message

(0) Share

Report

Posted on by bolandre92

Hi,

I have a form connected to a Sharepoint list, when I clicked New in SharePoint I did not get the form data and instead I got a message saying "Getting your data". I solve that, writing the following in the Item section of the form: If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@EMPLEADO]),SharePointIntegration.Selected), however, it is not helpful to get the values of the first row every time the user has to create a new record.

Is there any other workaround for this issue?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 154,799 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @bolandre92 ,
What exactly are you trying to do here? A new record will not have any fields completed when opened, unless there are Defaults in either the data source or the relevant card. The code below is standard and would not initiate on a new form.
If( IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected), First([@EMPLEADO]), SharePointIntegration.Selected )
Are you trying to put something as Default in some fields?

Was this reply helpful? Yes No
bolandre92 73 on at

Like (0)

Report
Copy link

Link copied!

Thank you @WarrenBelz

I had to place that code because when I opened the Form in Sharepoint, it did not show anything and instead a message saying "Getting your date". Answering your question, I want the Form in blank when a user click the NEW buttom.

thks,

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@bolandre92 ,
What is your OnNew code?

Was this reply helpful? Yes No
bolandre92 73 on at

Like (0)

Report
Copy link

Link copied!

Here is what I have:

NewForm(SharePointForm1)

BTW, there is a screen attached on how things looks like if I eliminate the following code:

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@EMPLEADO]),SharePointIntegration.Selected)

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@bolandre92 ,
There is no reason your OnNew code should not produce a new blank form. I assume the other code you refer to is on the Item of the form. If so, this is irrelevant and will not affect a new form, but would certainly affect an Edit or View form (as it would not know what record to display).
It only really needs to be SharePointIntegration.Selected (that is what I set all mine to) - you might try this.
Also, what else have you changed as a standard form has all the necessary settings to work as it should.

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.

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @bolandre92 ,

I just found there are multiple EditForm controls in the app, right?

Once the EditForm is in New mode by NewForm(FormName) code, all fields will show in blank. So you need to modify the OnNew property as follows to set Mode of All EditForms to New.

OnNew: NewForm(FormName1);NewForm(FormName2);NewForm(FormName3)

Hope this helps.

Sik

Was this reply helpful? Yes No
bolandre92 73 on at

Like (0)

Report
Copy link

Link copied!

@v-siky-msft

Thank you, it worked perfectly.

@WarrenBelz

Thank you for your continuous support always.

Was this reply helpful? Yes No