I receive this message "Office365.SendEmail' has an invalid value for parameter 'To" because I am using at OnSelect;
Office365.SendEmail(Gallery1.Selected.'E-Mail',"Thank you for visiting" , "You have been de-registered")
But not everyone fills in the e-mail field: Gallery1.Selected.'E-Mail' which causes the error.
How can I prevent the error without making the field a mandatory field?
Did what you suggested and now have in the OnSelect of the Button;
If(IsBlank(Gallery1.Selected.'E-Mail'),"",Office365.SendEmail(Gallery1.Selected.'E-Mail',"Thank you for visiting" , "You have been de-registered"))
But I still receive the same error message.
Hi @SdR1,
An error message would be returned whenever a required parameter is blank in the function.
Please take a try with the following code which will send out the email without issues:
Add a button under the gallery and set its OnSelect property:
If(IsBlank(BrowseGallery1.Selected.EmployeeName.Email),"",Office365.SendEmail(BrowseGallery1.Selected.EmployeeName.Email,"test","details"))
Best regards,
Mabel
WarrenBelz
89
Most Valuable Professional
MS.Ragavendar
58
Michael E. Gernaey
42
Super User 2025 Season 1