variables creation for email body

(2) Share

Report

Posted on by MR-30031723-0

Hello guys,

I need to declare a variable in PowerApps, I am doing the following and DAX syntax does not allow it:

Set(

    EmailBody;

    "<p>Text of my variable</p>"

);;



Office365Outlook.SendEmailV2(

    PeopleAddedGallery4.Selected.Mail;

    "EMAIL Subject";

    EmailBody;

    { IsHtml: true }

)

for the Set expression gives the error: invalid number of arguments received 1, expects 2.

Thanks in advance.

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Verified answer

Vish WR 1,043 on at

Like (2)

Report
Copy link

Link copied!

@MR-30031723-0

This isn't a DAX issue — Power Apps uses its own formula language, not DAX.

The problem is the semicolons as argument separators. In most Power Apps environments the delimiter is a comma, not a semicolon. So your Set() is being read as one argument instead of two, hence that error.

You could try this

Set(EmailBody, "Text of my variable")

Office365Outlook.SendEmailV2(

PeopleAddedGallery4.Selected.Mail,

"EMAIL Subject",

EmailBody,

{ IsHtml: true }

)

Note :

Also drop the ;; double semicolons — those aren't needed in Power Apps at all.

If your tenant is set to a locale that uses semicolons as separators (some European regions do), then semicolons would be correct and the issue is something else — but the comma version is worth trying first

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
MR-30031723-0 33 on at

Like (1)

Report
Copy link

Link copied!
@Vish WR thank for your proper reply, I would like to know all the details for the PowerApp language acording my region settings(do you know where to find those specifications?) Thank you very much your answer really helped me with the issue I was having. Still my sentence in the section:
Office365Outlook.SendEmailV2( PeopleAddedGallery4.Selected.Mail, "EMAIL Subject", EmailBody, { IsHtml: true } )

It highlights the Office365Outlook.SendEmailV2 function and the comma right after the Mail argument, and it throws the error message:

"Unexpected characters. The formula contains a 'Comma' where 'ParenClose' is expected."

The arguments look correct to me, so what could be the problem?

Thank you once again,

Manuel Rivera

Was this reply helpful? Yes No
Verified answer

Vish WR 1,043 on at

Like (1)

Report
Copy link

Link copied!

@MR-30031723-0

Let me see if i can find any reference for locale setting

https://www.reddit.com/r/PowerApps/comments/1jgggzv/different_syntax_for_different_languages/#:~:text=Why%20is%20that%20a%20thing,WHY?

Was this reply helpful? Yes No
MR-30031723-0 33 on at

Like (1)

Report
Copy link

Link copied!

I am stuck with an expected operator error in PowerFx and I cannot move forward.

Considering that my first expression works correctly using commas, I assume that my argument delimiter should still be a comma.

For example, this works without issues:

Set(EmailBody, "Text of my variable")

However, when I try to send the email using Office365Outlook.SendEmailV2 with all the arguments defined, I get the following error:

"Expected an operator such as +, * or & at this point of the formula"

This is the code I am using:

Office365Outlook.SendEmailV2( PeopleAddedGallery4.Selected.Mail; "EMAIL Subject"; EmailBody; { IsHtml: true // Attachments: // ForAll( // AttachmentsControl1.Attachments; // { // Name: ThisRecord.Name; // ContentBytes: ThisRecord.Value // } // ) }; )

No matter what I try, I cannot get past this error.
My goal is to be able to send the email with all these arguments properly defined, including HTML body and attachments.

What am I doing wrong with the argument delimiters or the function syntax?

Was this reply helpful? Yes No
Vish WR 1,043 on at

Like (0)

Report
Copy link

Link copied!

@MR-30031723-0

Can you see if this works?

Office365Outlook.SendEmailV2(
PeopleAddedGallery4.Selected.Mail,
"EMAIL Subject",
EmailBody,
{
IsHtml: true,
Attachments:
ForAll(
AttachmentsControl1.Attachments,
{
Name: ThisRecord.Name,
ContentBytes: ThisRecord.Value
}
)
}
)

Was this reply helpful? Yes No
MR-30031723-0 33 on at

Like (0)

Report
Copy link

Link copied!

still the same error in the underlined line ("Expected an operator such as +, * or & at this point of the formula")

Was this reply helpful? Yes No
Vish WR 1,043 on at

Like (0)

Report
Copy link

Link copied!

Office365Outlook.SendEmailV2(
PeopleAddedGallery4.Selected.Mail,
"EMAIL Subject",
EmailBody,
{
IsHtml: true,
Attachments:
ForAll(
AttachmentsControl1.Attachments,
{
Name: ThisRecord.Name,
ContentBytes: ThisRecord.Value
}
)
}
)

Was this reply helpful? Yes No
MR-30031723-0 33 on at

Like (2)

Report
Copy link

Link copied!
Thank you for swearing with me looking for the solution.
I found the solution:

Set(EmailBody, "Text of my variable"); <-- this semicolon was missing

Office365Outlook.SendEmailV2(

PeopleAddedGallery4.Selected.Mail,

"EMAIL Subject",

EmailBody,

{ IsHtml: true }

)

the semicolon after the first expression was missing. I almost died on the way.

Was this reply helpful? Yes No