cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SunnyJess
Level: Powered On

submit button to data file

Hi All,

 

PowerApps newbie here.

 

I have created an app which picks different lists from excel tables to create a data form which needs to be submitted to a diferent excel table. 

 

I have attached a pic of what the app looks like to give you an idea.

 

When I hit the submit button I want the data on the page to be submitted to a data table in excel.  Each time the submit button is entered, I want it to create a new entry in the data table.

 

I have used the submit form action {SubmitForm(<Data Table>} but I am receiving an error which says "the function expects an editable form as its input"

 

How do I get the submit button to save as per the directions above please.

8 REPLIES 8
Ashok111
Level: Powered On

Re: submit button to data file

If you did not change default form name, it should be SharePointForm1, for example.

 

so

 

try

 

SubmitForm(SharePointForm1)

 

SharePointForm1 knows where to send data automatically.

 

HTH

Ashok

Super User
Super User

Re: submit button to data file

SubmitForm() works with the edit form and the parameter it takes is a Form Name. If you aren't using a form control to update the data in Excel then you need to use the Patch function to update the Excel data source.

 

 

SunnyJess
Level: Powered On

Re: submit button to data file

I still get "the function expects an editable form as its input" error

SunnyJess
Level: Powered On

Re: submit button to data file

I have no idea what any of that means Jeff. Sorry.

Ashok111
Level: Powered On

Re: submit button to data file

Are you trying "SubmitForm()" ?

If so, this will not work.

 

In the parenthisis, you need to supply the formname.

 

What is the name of your SharePont form?

 

Thanks,

Ashok

SunnyJess
Level: Powered On

Re: submit button to data file

Hi Ashok,

 

Yes the parenthisis contain the form name... SubmitForm('Purchase Order Form')

Colleen
Level: Powered On

Re: submit button to data file

Did you ever get this fixed? I'm encountering a similar problem in that my edit form isn't being submitted with the same error as you

Matteo
Level: Power Up

Error: "the function expects an editable form as its input."

Dear all,

 

I really need help to solve this error:

 

I have build a form in Powerapps to fill in a Share Point list. The form is populated with the fileds from the list. However when filling the form the data do not gwet saved in the list.

 

In Powerapps I have this error: "the function expects an editable form as its input.".

 

How can I solve it?

 

Thank you