cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MattyH
Level 8

Error reported in Edit Form Submission

I am trying to create my first Edit Form, and have an issue when trying to submit the completed form.

 

The following message comes up, and I have no idea how to fix it. Any help would be appreciated.

 

The requested operation is invalid.

Server Response: ')' or ',' expected at position 10 in 'New Account'

 

Thanks in advance.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Error reported in Edit Form Submission

Hi @TopShelf-MSFT,

I'm not quite sure what the answer to this is.

 

@MattyH - is this the same issue as the 'duplicate record' problem that you mentioned here, or is it a separate problem?

 

https://powerusers.microsoft.com/t5/General-Discussion/Error-in-Position-9/m-p/201937#M64980

 

View solution in original post

MattyH
Level 8

Re: Error reported in Edit Form Submission

My apologies, I should have closed this, but forgot about it.

 

I have, more by luck than judgement, solved it myself.

 

As it turns out, one of the required fields in the edit form was automatically filling, so when the user added another entry into the same field, it would not save.

 

Thanks.

View solution in original post

13 REPLIES 13
Super User
Super User

Re: Error reported in Edit Form Submission

Hi @MattyH

I suspect there's an error in the formula for your submit button.

Could you show us the OnSelect formula for your submit button?

MattyH
Level 8

Re: Error reported in Edit Form Submission

Hi @timl

 

The formula for On Select is below.

 

SubmitForm(Form1);ResetForm(Form1)

 

Thanks.

Super User
Super User

Re: Error reported in Edit Form Submission

The OnSelect formula looks fine so I don't think that's the source of the problem.

To help diagnose this further, what data source are you using? SharePoint? What is 'New Account' and can you think of any formula that you have in your app that refers to this?

Also, it might be of some help if you could screenshot this error.

MattyH
Level 8

Re: Error reported in Edit Form Submission

Hi @timl,

 

The Datasource is Dynamics 365.

 

I assumed the 'New Account' was the new data that would be sent to Dynamics, there is nothing else in the app that I can think of that refers to this.

 

I will sort a screenshot shortly, but am unable to access at the moment.

 

Thanks.

MattyH
Level 8

Re: Error reported in Edit Form Submission

@timl.

 

Screenshot attached.

Super User
Super User

Re: Error reported in Edit Form Submission

Hi @MattyH

The part of the error message that I find interesting is 'The data source may be invalid'.

To diagnose this further, I would create a new 'auto-generated' app by selecting the 'Start from data' option. You can use this to confirm that you read and write data to your Dynamics 365 data source. If this works, you can compare the settings in the Edit form settings to try and work out more precisely the cause of your error.

MattyH
Level 8

Re: Error reported in Edit Form Submission

Thanks @timl, I will give it a shot.

 

I'll let you know how I get on!

MattyH
Level 8

Re: Error reported in Edit Form Submission

Hi @timl,

 

Just tried your suggestion, same issue there, I'm afraid.

 

I appreciate the assistance, I will have to keep trying though!

 

Matty.

MattyH
Level 8

Re: Error reported in Edit Form Submission

I have just tried this again, using a different entity, and the new record was written to Dynamics 365 instantly and without any issues.

 

This is getting quite confusing...

 

Matty H

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 440 members 6,079 guests
Please welcome our newest community members: