PowerApp form behavior different depending on where form is being filled out

[nelsonsaenz]

Hello,

I am building an onboarding form SharePoint list using the PowerApp integration. I'm trying to solve an issue I am having depending on where someone accesses the form from.

If someone navigates directly to the SharePoint list and clicks the New button, a blank form loads, which is the correct behavior. 

I also have embedded the PowerApp as a web part on our onboarding SharePoint site. When it loads on the SharePoint page, it loads with the first record from the SP list by default. I have attached screenshots of both scenarios. I would like the embedded app to load blank like it does when you click New from the SharePoint list. Thanks in advance for your help.

Nelson

 

 

 

[Akash17]

Hi

If you are working with form in powerapps then you can use ResetForm(Formname);NewForm(FormName)

Correct me if I am not understood your question

[nelsonsaenz]

Hello,

Thank you for your reply. I tried applying the code you provided but the result is the same. Here is a screenshot. 

 

Thanks.

Nelson

[v-yujincui-msft]

Hi @nelsonsaenz ,

By default, it loads the first record in the SP list which should be related to the formula on the Form's Item property.

Maybe you could try the following formula:

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),LookUp(datasource,ID=0),SharePointIntegration.Selected)

This formula is to find a non-existent record, which may cause the form to not display any data.

In addition, maybe you could try to add an extra button and set its OnSelect property to NewForm(SharePointForm1)

Hope it will work.

Best Regards,
Charlie Choi

[nelsonsaenz]

Hi Charlie,

I plug in that formula and it gives me an error and when I test the form, it's completely blank with message No Item to Display. The button addition may be a good stopgap if I can't figure out how to have it load with a blank form. Speaking of buttons, what is the command for submitting a form like when you hit save from the SharePoint List?

Thanks.

Nelson

[nelsonsaenz]

Forgot to add the screenshot

 

[v-yujincui-msft]

Hi @nelsonsaenz ,

I usually use the default formula.

SubmitForm(SharePointForm1)

Best Regards,
Charlie Choi