How to count total number of users in office 365 connector using PowerApps

(0) Share

Report

Posted on by Community Power Pla...

Hello,

Is there any way to count Total number of employees in an organization using office 365 connector using PowerApps.

Regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Tchesco Ayih 152 on at

Like (0)

Report
Hi,
This will help you count the total number of employees in the office 365
CountRows(Office365Users.SearchUser({searchTerm:TextInput1.Text}))

Hope this helps.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @Tchesco ,

I have tried the same formulae but getting the error! My motive is to display the total number of users , I have used a label control and applied this formulae on text property of the label
I have attached the screenshot. Could you please check and help on this?

Total number of u...

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report
Hi @Anonymous ,

I am assuming you have a Text Input called TextInput1 ? If you simply want the total number of users

CountRows(Office365Users.SearchUser({top: 999}))

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello @WarrenBelz ,

Thanks for your response. But there is no Text Input field, there is just a Text Label, I need to display the total number of employees in the Organization using the office 365 connector.

I have checked the formulae, but it is displaying only 999, but is there any way to display the total number of Employees?

Was this reply helpful? Yes No
Tchesco Ayih 152 on at

Like (0)

Report
@Anonymous

Put the code inside the text property of your label
CountRows(Office365Users.SearchUser({top: 999}))

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report

@Anonymous ,

The maximum number able to be returned is 999 - you can refine the search with another filter such as Department, but you cannot count more than this.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No