Unanswered

Send email from PowerApp with listbox

(0) Share

Report

Posted on by fcnchuck

Attempting to send an email to a hard coded email address using the data that is displayed in a ListBox item. Here is what i am using currently

Office365Outlook.SendEmail("user@email.com", Subject, "List: "&Concat(Box1.Selected.Result&))

The issue i am having is the email is delivered, but the only thing i see in the body is "List:". Nothing from the ListBox is making it to the body of the email.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

mdevaney 29,989 Moderator on at

Like (0)

Report
@fcnchuck
I believe this code segment is the problem. Concat has 2 paramters: (Table, Formula).

Concat(Box1.Selected.Result&)

Does your email show the proper info with this code instead? I chose SelectedItems instead because it references a Table even if a single row is selected.

Concat(Box1.SelectedItems,Result&" ")

---
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."

Was this reply helpful? Yes No
fcnchuck 16 on at

Like (0)

Report

Just tried and now get this error within the editor -

"Invalid number of arguments: received 1, expected 2-3"

@mdevaney

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@fcnchuck
Formula bar screenshot please with error underlined.

Was this reply helpful? Yes No
fcnchuck 16 on at

Like (0)

Report

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@fcnchuck
Please replace the period ( . ) after SelectedItems with a comma ( , ) as shown in my code example above.

---
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."

Was this reply helpful? Yes No
fcnchuck 16 on at

Like (0)

Report

Thank you- that was a silly mistake. Here is what i get now via email -

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@fcnchuck
Are you certain Result is the correct column name when used in this formula? Perhaps you have the wrong column or maybe result is loaded with blank values. I've tested the solution on my side and do not have any issues.

Try to experiment by putting my code in the text column of a label and modify it until the desired result is achieved.
Concat(Box1.SelectedItems,Result&" ")

---
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."

Was this reply helpful? Yes No
fcnchuck 16 on at

Like (0)

Report
@mdevaney

Here is how my listbox is created that i am referencing to pull the final data from

Distinct(Filter(Source, 'Employee' = Employee.Selected.Result, Division=Division.Selected.Result, 'Office' = Office.Selected.Result, 'Cost'=Cost.Selected.Result), 'Adds')

'Adds' is the column in my data set that the final information is being selected from. I attempted to use the Adds column in what you suggested but no luck.

It does not appear to be returning blank values as i can see them visible in my listbox on the same screen before i attempt to generate my email. Here is what my screen looks like

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@fcnchuck
I am having issues replicating your situation on my side successfully. When I make a listbox that looks like yours using the DISTINCT function I can successfully CONCAT the string and have it appear in a label. There is something in your app I am not seeing and at this point I admit I am stuck.

@v-xida-msft @v-yutliu-msft
Any thoughts on where to go from here?

Was this reply helpful? Yes No
fcnchuck 16 on at

Like (0)

Report

Thanks for all your help @mdevaney

It is not out of the realm of possibility that something else in my app would be stopping the data from being passed to email. Im just not sure what that could be as the rest of the app functions are all working. I used Shane Young's guides/videos to assist as i went through building this app. Not sure if he is active here and able to tag.

Was this reply helpful? Yes No