cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
fcnchuck
Regular Visitor

Send email from PowerApp with listbox

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.

10 REPLIES 10
Super User
Super User

Re: Send email from PowerApp with listbox

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

fcnchuck
Regular Visitor

Re: Send email from PowerApp with listbox

Just tried and now get this error within the editor -

 

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

 

@mdevaney 

Super User
Super User

Re: Send email from PowerApp with listbox

@fcnchuck 

Formula bar screenshot please with error underlined.

fcnchuck
Regular Visitor

Re: Send email from PowerApp with listbox

22.png

Super User
Super User

Re: Send email from PowerApp with listbox

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

fcnchuck
Regular Visitor

Re: Send email from PowerApp with listbox

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

Super User
Super User

Re: Send email from PowerApp with listbox

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

fcnchuck
Regular Visitor

Re: Send email from PowerApp with listbox

@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

 

44.png

Super User
Super User

Re: Send email from PowerApp with listbox

@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?

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,992)