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

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

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

 

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