Hi,
I've looked everywhere and can't figure out whats going wrong here.
I'm drawing from a sharepoint list and filtering emails based on muliselection choice field. I then want to send an email to all people who meet the criteria. I use the following formulas, and it works in a text box, but wont send the email.
Here, Title is the email Address.
SendEmailV2(Concat(Filter(AddColumns(Emails,"CategoryTest",Category.Value), "New Booking" in CategoryTest).Title,Title,";"),"Subject","Body")
The Concat formula works perfectly when I test it in a text box, but here in the button onselect when sending an email it says that it coudnt find any data when I hover over 'Emails'
Can anyone help me with this?
