Share
Report
16Hi
I am testing sending emails within PowerApps. My main source is here (Shane Young send email)
I have created a combo box linked to the Office365User connector to search to capture the people I wish to email in my organisation.
The combo items is set by the following, where DataCardValue153 is the combo box
Office365Users.SearchUserV2({searchTerm:DataCardValue153.SearchText}).value
The update statement in New form mode for the data card is
Concat( DataCardValue153.SelectedItems, Mail,";")
This works and the data sored in the SQL table is fred.flintston@somedomain.com;barney.rubble@somedomain.com etc
The question I have is how to set the default of the combo box from the data retrieved from the SQL datatable when the form is in Edit Mode?
So when in edit mode the combo box would show the users, so far I have tried
Default = Filter(Table(Office365Users.SearchUserV2()) ,Mail in (Split(ThisItem.EmailRoute,";"))
however, my datatypes are incorrect
Any advise or pointers welcome
All responses (
Answers (
