You’re offline. This is a read only version of the page.
16
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
Share
ReportOffice365Outlook.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.
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.
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.
Any thoughts on where to go from here?
Here is how my listbox is created that i am referencing to pull the final data from
All responses (
Answers (
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
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."
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."
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."
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
