Flow that detect when user-account is created or deleted?

[Oskarkuus]

Hey

I have a need of building a power automate flow that detect when a new user is created or deleted.

I can not find any connections for this tho (i am global admin).

Is there a way today to do this with flow?

I want to build a flow that informs people when users are created and deleted so we can keep track on new people and remove things when ppl are removed.

[ChrisPiasecki]

Hi @Oskarkuus,

You can achieve this using a Webhook trigger (When a HTTP Request is Received). You can subscribe to Microsoft Graph API  created and deleted change events for a User. The article below does a good job of explaining how to subscribe to Graph API events, then using Azure Logic Apps (Power Automate is Logic Apps under the hood with some minor differences).

https://gotoguy.blog/2020/07/12/subscribing-to-teams-presence-with-graph-api-using-power-platform/

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[Oskarkuus]

Thanks. That looks interesting. But i think the webhook command needs a premium license.

I came up with an idea to fill a sharepoint list with all users and then compare that list to all useraccounts once every hour. That would give me new accounts and deleted.

I think.... 

[ChrisPiasecki]

Hi @Oskarkuus,

Yes you could do something like a full sync every hour, but keep in mind this method will have challenges scaling, especially at a high volume of users. Depending on the actions performed in your flow, you could run into throttling limits if not careful, so keep that in mind while building/testing.

Webhooks are often more efficient than constant polling and can receive the information in near real time, but if premium connectors are a dealbreaker, then you may have to look at your alternate method.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[Oskarkuus]

What throttling limits are there?

I hav 3500 users.

Wont it work with pagination and raising throttling value to 2000?

[ChrisPiasecki]

Hi @Oskarkuus,

The Power Platform throttling limits are documented here. Note that for flow each action counts as a request, so if you're iterating through large collections, you could eat up daily API limits.

https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations#request-limits-...

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[Oskarkuus]

What, do you mean my 2000 api limit eats up if i do a get items on a sp list and then do a for each loop? Will that be one api call per for each pass?

Still dont really understand pagination. Will i be able to get all items if there are more than 2000

[ChrisPiasecki]

Hi @Oskarkuus,

The get items request will take up a request (and another if fetching more via paging). To be honest I'm not sure if it's a full 1 request per every single action or if some actions are more expensive than others based on memory/compute, the documentation isn't clear on that, and I haven't ran into throttling limits yet myself or tested it (I have a Dynamics plan though). 

With Pagination you should be able to retrieve more records yes, it just means an extra request is needed to fetch the next batch.

I think your best bet is to try your method out first and see if works without any throttling issues, then look at alternatives like the one I suggested.

Hope this helps. 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[Oskarkuus]

Thank you.

Just one last question  🙂

If for example one request of get items is one request.

Then if i do one request, load 2000 people and for example, then run "send one mail to each person". Will each mail be one request. So if i would do so, that would mean a total of 2001 requests that specific run of that flow and i would be over my current limit.

Understand that it might not be fully transparent and all info is not documented... but whats your guess

[ChrisPiasecki]

Hi @Oskarkuus,

That sounds about right. Best way to confirm is test it using a test account if you have one so you don't impact existing flows that you own.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[Oskarkuus]

How do u mean test? Test do 2001 mails and see if i cap out? How do i see how many are left? 

[ChrisPiasecki]

Hi @Oskarkuus,

I wouldn't test 2000 emails with the Outlook 365 connector as it has its own throttling limits, just like other connectors that will have their own throttling limits that are separate to Power Automate's limits.

There is no report currently that tells you what your daily remaining quota is. You can take a look in the Power Platform Admin Center under Analytics at the different reports there, the Connectors tab under Flow analytics will be of most relevance I think.

https://docs.microsoft.com/en-us/power-platform/admin/analytics-flow#connectors-report

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[WillPage]

What you're trying to do here is way beyond the intended use for Power Automate. You really ought to be looking at Logic Apps, where such trivialities as a daily API limit are not a factor.

[ChrisPiasecki]

Hi @WillPage,

If going the Logic Apps route, then "premium" connectors become no longer a thing then the Graph API route is, the way to go because cost consumption will be significantly lower due to the compute and API calls.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[WillPage]

Indeed. I don't understand the resistance to using Logic Apps I often hear of.
While some people might be working in large bureaucratic organisations and it can genuinely be very difficult to get access to an Azure subscription , in most cases if you're at the level of needing Logic Apps, in terms of the complexity of your flows, you should also be able to make a pretty good business case for the handful of pocket change it'll cost.

[Oskarkuus]

Can i test logic apps, how?

I am global admin

But we dont have any premium license for power tools

How can i test and is it same things as building flow?

[ChrisPiasecki · Accepted solution]

Hi @Oskarkuus,

Azure Logic Apps are provisioned like other Azure resources, this can be through the Azure Portal, via Azure Resource Manager (Arm) templates, Azure CLI or Azure PowerShell. There is also an extension for Visual Studio Code to help with authoring and deploying. 

There is no such thing as premium connectors in Logic Apps, but instead you pay per consumption, much like other Azure resources. There are a few subtle connectors that are exclusive to one or the other (e.g. Approvals are Power Automate only. More information is documented here.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[ChrisPiasecki]

Hi @Oskarkuus,

Just following up, were the above steps helpful and did you get the answer you needed?

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.