cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Powerapp with request form not working, please help

Hi, I have added a screen and inserted a form and connected this to a sharepoint list.  I was able to successfully add the list, but I am having difficulty getting this form to work and update sharepoint as I submit the form as a test.

 

I did add defaults("sharepoint list") under Item.  Also on the submit button and onselect added Submitform("Form Name").

 

What else do I need to check and insert for this to work and update into sharepoint?  Also, what is the function for "Icon Cancel".

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Powerapp with request form not working, please help

Hi @Suridup ,

Yeah, if the Title field is a Required field in your SP List, you must enable it within your Edit form. For adding a Title Data card in a Edit form, please refer to the following screenshot:

9.JPG

 

The List separator (',') is based on language, some regions use ',' as list separator, other regions use ';' as list separator. On your side, please consider modify your formula as below:

Patch('D365 Content Request'; Defaults('D365 Content Request'); 'Content Request Form'.Updates);;
ResetForm('Content Request Form')

 

Please consider take a try with above solution, check if the issue is fixed.

 

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.

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Powerapp with request form not working, please help

Hi @Suridup ,

Could you please share a bit more about your scenario?

Do you want to submit a new record back to your SP List using the Edit form?

Do you mean that the Edit form could not 

 

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please make sure set the DefaultMode property of the Edit form set to following:

FormMode.New

then remove the formula within the Item property of the Edit form, then try your SubmitForm function again, check if the issue is solved.

 

In addition, I also think the Patch function could achieve your needs. I have made a test on my side, please consider take a try with the following workaround:

Set the OnSelect property of the "Submit" button to following:

Patch(
       'SP List',
       Defaults('SP List'),
       EditForm1.Updates        // EditForm1 represents the Edit form in your app
);
ResetForm(EditForm1)

 

Please consider take a try with above solution, check if the issue is solved.

 

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.
Highlighted
Frequent Visitor

Re: Powerapp with request form not working, please help

Hi,

Yes, I want users to complete the request form and then hit submit.  Once submit is actioned, the completed fields need to update my sharepoint list.  Please also see screenshot of the sharepoint list.  Can it be that "Title" has to be in the form for it to work?  How do I add a "Title" contact card if it should be there?

 

I did the below, but the Patch function has an error.  I dont know why, but for me, I cannot use "," but it accepts ";", however, when I get to the Resetform function, it gives me an error.  Please see screenshot attached.  If I test it, it doesnt update to my sharepoint list.

 

Highlighted
Community Support
Community Support

Re: Powerapp with request form not working, please help

Hi @Suridup ,

Yeah, if the Title field is a Required field in your SP List, you must enable it within your Edit form. For adding a Title Data card in a Edit form, please refer to the following screenshot:

9.JPG

 

The List separator (',') is based on language, some regions use ',' as list separator, other regions use ';' as list separator. On your side, please consider modify your formula as below:

Patch('D365 Content Request'; Defaults('D365 Content Request'); 'Content Request Form'.Updates);;
ResetForm('Content Request Form')

 

Please consider take a try with above solution, check if the issue is fixed.

 

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.

View solution in original post

Highlighted
Frequent Visitor

Re: Powerapp with request form not working, please help

Thanks!

 

This worked!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,053)