cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
G99
Post Prodigy
Post Prodigy

Help with PowerApps forms

Ive got a separate question logged which is only partially related, so I thought id be more specific with a new question.

I'm trying to create a form for a SharePoint online modern list.

When I go to https://make.powerapps.com and click Apps - New app - canvas - from start with your data I select SharePoint Phone layout - select my site and my list - connect The form renders correctly as I have 0 items in the list, when I click + I can see the columns and I when I complete the form and click submit I get an error There was a problem saving your changes. The data source may be invalid

If I https://make.powerapps.com and click Apps - New app - canvas - blank app tablet layout - View Data sources - SharePoint as connector - select my account - select the site - select the list - connect. The Add an item from the insert tab or connect to data message wont go away. Even though I have on the data sources my list name visible in the left of the screen.

What am I doing wrong?

Ideally I don't want to use a phone layout and would prefer to use a tablet layout, but just trying to get this first stage to work, any help would be appreciated.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Eelman
Super User
Super User

@G99 on your first attempt, did you save the app first before submitting the form? Also, make sure you are filling in ALL required fields (should show '*'s beside them) in your form. The submit will fail if these aren't completed.

 

Maybe share some screenshots if the above tips don't work

View solution in original post

5 REPLIES 5
SeanHenderson
Impactful Individual
Impactful Individual

Hi,

I'm having trouble understanding the issue.

First, if you want the form to be used in SharePoint, have you considered the Customize Forms option? This is located on the Power Apps button found in the top navigation of your SharePoint list. You can also try building your app from this screen.

 

But it sounds like you want to use tablet layout, in which case Start From Data is not an option. 

If you have started from blank, and connected to your data source, the message to insert or add a source will remain until you start adding components. Bear in mind, with the start from blank option, you will be building what you saw in the Start from Data option entirely yourself, including the gallery and forms.

 

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

Eelman
Super User
Super User

@G99 on your first attempt, did you save the app first before submitting the form? Also, make sure you are filling in ALL required fields (should show '*'s beside them) in your form. The submit will fail if these aren't completed.

 

Maybe share some screenshots if the above tips don't work

v-xida-msft
Community Support
Community Support

Hi @G99 ,

Please make sure you have already enabled all Required/Mandatory fields within the Edit form of your app. You could also consider submit your form data into your SP list using Patch function instead of SubmitForm function. Please set the OnSelect property of the "Submit" button to following:

Patch('YourSPList', Defaults('YourSPList'), EditForm1.Updates)

 

In addition, if you want to create form for your SP Online List using PowerApps, I think "Customize forms" option under "PowerApps" menu in SP Online List could achieve your needs:

6.JPG

 

More details about creating a custom form in SP List, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-list-form

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I just realized I had a missing required field missing from the form, which I have now added onto the form, and the form saves

My issue still is that I cannot use the tablet layout as mentioned in my first post

Also I didn't want to use the option from within SharePoint to create the form, as this then changes the default SPO form to the PowerApps form, I would rather create an app and direct users to the form via the app URL, else there is a chance users will directly edit the SPO list

SeanHenderson
Impactful Individual
Impactful Individual

@G99 

You can build a tablet form, but not with the Start With Data option. You will have to use the Blank App option and build the three screens yourself. 

Annotation 2019-12-10 090854.png

It's not too hard to build a three screen app. Try this tutorial by Audrie Gordon:

https://www.youtube.com/watch?v=k94UJe0JBQA&feature=emb_title

 

Let me know if you need any help with it!

 

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,898)