cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to get the length of an array ?

Hello there !

 

I have a sharepoint multi-line column where i store users' email separated by a ";;", like following :

johndoe@organization.com;;janedoe@organization.com;;calamityjane@organization.com

 

In Powerapps,i would like to count how many passenger email I got.

In other languages/logics, i would do a simple length(split(PassengerEmail,";;")), but unfortunately there is no such thing in powerapps !

 

Any idea on how to proceed ?

 

Thanks a lot, have a wonderful day!

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft
Community Support
Community Support

Try this:

CountRows(
Split("johndoe@organization.com;;janedoe@organization.com;;calamityjane@organization.com",
";;")
)

Which should be the same as the function you posted.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-micsh-msft
Community Support
Community Support

Try this:

CountRows(
Split("johndoe@organization.com;;janedoe@organization.com;;calamityjane@organization.com",
";;")
)

Which should be the same as the function you posted.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi Michael,

Thanks a lot, I might have not read the article on Count until the end ..

This does exactly what i was wanting !

Have a nice day !

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,928)