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))
Add a custom column，use following code:
List.Count(Text.PositionOf([Group.Owners], "@", Occurrence.All))
Oh, great solution, but I get this error:
Expression.Error: We cannot convert the value null to type Text.
Details:
Value=
Type=[Type]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.
