You’re offline. This is a read only version of the page.
121
I have a SharePoint List which is used to grab the email addresses from 1 column and emails everyone in the list however i have had to add a Location column now which means i can't sent the email to everyone.
My List is called Overtime_Email and the 2 columns are called GroupEmail & Location.
I have a dropdown on the front screen Called DropDownLocation.
The drop down is powered by the location from the Overtime_Email list, what i'm trying to do is create a collection to grab only the email addresses from the SP List which match the selected location from the dropdown.
Mark
Thanks royg,
Still getting the same issue, i've created a text field in the data base and can patch the data over when the user creates the record and this works, i've added the ClearCollect to the beginning and now using the following incase anyone else looks for some thing similar.
Share
Report
All responses (
Answers (
ClearCollect(Emails,ShowColumns(Filter(Overtime_Email, LocationText = DropdownLocation.Selected.Value), GroupEmail))Thanks royg, I was looking at this way but got the same error that i'm getting now.
Incompatible types for comparison. These types can't be compared: Record, Text.
The Location field in the Overtime_email SP is a dropdown selection, the error is falling on the = aspect of the code.
Any ideas around this?
If you only care for the email column, add a ShowColumns call:
ShowColumns(Filter(Overtime_Email, Location = DropDownLocation.Selected.Value), GroupEmail)Thanks royg, I utilise this within my gallery to define which records to show but I want to be able to collect the data from the SharePoint list so I can email the specific individuals from a specific location.
Does this make sense.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
