Forum Discussion

MathildaBackman's avatar
MathildaBackman
Helper I
1 year 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
    1 year 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
1 year 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
1 year 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