Forum Discussion
Solved
Count e-mail addresses
I have a table that contains different SharePoint sites. I have a column called Group.Owners where I have the e-mail address to the owner/owners of that site. There can be none, one or multiple e-m...
Because some cell is null in Group.Owners column, you can use following code:
List.Count(Text.PositionOf([Group.Owners] ?? "", "@", Occurrence.All))
Because some cell is null in Group.Owners column, you can use following code:
List.Count(Text.PositionOf([Group.Owners] ?? "", "@", Occurrence.All))
Works well no. Just needed to click "Don't summerize" when I added the values from that column in my table.
Thank you for the code and the help.