Answered

Expected Operator Error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all, I would appreciate your help.

I am currently receiving this operating error which is causing my submit button to not work. It is trying to run a Microsoft flow. If anyone has any insight on the issue that would be great.

Please see the attached screenshot for some detail of my formula.

Thank you for your help in advance.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

I would first recommend that you change your Submit formula to : SubmitForm(EditForm1) and then move the remainder of the formula to the OnSuccess action of EditForm1. This way you are only running the flow if the submit is successful. As you have it now, the flow will run regardless of the success of the submit.

Then, in your OnSucces, change your formula to the following:

'PowerAppsbutton-2'.Run( EditForm1.LastSubmit.Approver.Email, User().FullName, EditForm1.LastSubmit.'Material Number', EditForm1.LastSubmit.Description, EditForm1.LastSubmit.AdjustmentID ); NewForm(EditForm1)

Your formula was missing single quotes around the Material Number column.

I hope this is helpful for you.
mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

The word Material Number has a space between it. You must put this word between single quotes.

'Material Number'

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy, Thanks for your help. This should be a good solution I can implement.

I did just have a question regarding how to access the specific formulas for each aspect of the button. I have looked in the dropdown where the OnSelect formula is located but I cannot see another titled 'OnSubmit'.

If you could perhaps let me know how this can be done as I'm quite new to PowerApps.

Thank you for your help.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

I am not sure where you are getting "OnSubmit" from. Please re-read my reply, I believe you are confusing OnSuccess with it. And that is found ON your EditForm.

Correct me if I misunderstood your response.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

No you're right, I was getting confused. I apologise.

Thank you for your help, it is greatly appreciated.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

No problem...glad it was helpful.