Forum Discussion

MathildaBackman's avatar
MathildaBackman
Helper I
2 years ago
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...
Need Help
  • ZhangKun's avatar
    ZhangKun
    2 years ago

    Because some cell is null in Group.Owners column, you can use following code:

    List.Count(Text.PositionOf([Group.Owners] ?? "", "@", Occurrence.All))

     

ZhangKun's avatar
ZhangKun
Super User
2 years ago

Add a custom column，use following code:

List.Count(Text.PositionOf([Group.Owners], "@", Occurrence.All))

 

 

MathildaBackman's avatar
MathildaBackman
Helper I
2 years ago

Oh, great solution, but I get this error:

Expression.Error: We cannot convert the value null to type Text.
Details:
    Value=
    Type=[Type]

  • ZhangKun's avatar
    ZhangKun
    Super User
    2 years ago

    Because some cell is null in Group.Owners column, you can use following code:

    List.Count(Text.PositionOf([Group.Owners] ?? "", "@", Occurrence.All))

     

    • MathildaBackman's avatar
      MathildaBackman
      Helper I
      2 years ago

      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.

    • Papermain's avatar
      Papermain
      Frequent Visitor
      2 years ago

      I can see the ?? "" replaces the null values with empty text. Is there any documentation available about what the ?? exactly does and if there are other options as well? I cannot find anything and was not aware of this functionality