Error in two functions, when if has got two logical tests

Like (0) Share

Report

Posted on 28 Dec 2021 15:27:19 by Community Power Pla...

Hey, I have a question regarding a formula error,

I get an error: Unexpected characters. The formula contains 'ParenClose' where 'Comma' is expected.
for the formula:

Patch(Shortages,ThisItem,{Action:Dropdown2.Selected.Value}) ;
If(Dropdown2.Selected.Value = 'Action test'.Magazyn,
(Office365Outlook.SendEmailV2("pidom@gmail.com", "Subject", "Body" ),Dropdown2.Selected.Value = 'Action test'.MCO,
Office365Outlook.SendEmailV2("piter2@gmail.com","Subject","Body"))

I have the same question (0)

All responses (2)

Answers (1)

Community Power Pla... on 28 Dec 2021 at 15:40:55

Like (0)

Report

Re: Error in two functions, when if has got two logical tests

thanks 🙂

Was this reply helpful? Yes No
Verified answer

Pstork1 67,489 Most Valuable Professional on 28 Dec 2021 at 15:35:13

Like (1)

Report
Re: Error in two functions, when if has got two logical tests

I don't think you want the Open Parentheses in front of OfficeOutlook.SendEmailV2() The way it is now doesn't close that parentheses until the end of the statement, which means the IF never gets closed. Try this instead.

Patch(Shortages,ThisItem,{Action:Dropdown2.Selected.Value}); If(Dropdown2.Selected.Value = 'Action test'.Magazyn, Office365Outlook.SendEmailV2("pidom@gmail.com", "Subject", "Body" ), Dropdown2.Selected.Value = 'Action test'.MCO, Office365Outlook.SendEmailV2("piter2@gmail.com","Subject","Body"))

Was this reply helpful? Yes No