Answered

Powerapp with request form not working, please help

(0) Share

Report

Posted on by Suridup Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
Suridup Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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:

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,

Was this reply helpful? Yes No
Suridup Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks!

This worked!

Was this reply helpful? Yes No