Answered

Get inactive dataverse for teams environments with power automate

(0) Share

Report

Posted on by Nilsnutz

Hi everyone,

as you might know Microsoft is sending mails to environment creators and group owners if their dataverse for teams environment haven't had any "user activity" since x days. However we experience that the wording is very missleading and we continue to receive calls from users asking if their sharepoint site or teams channel will be deleted as well.

We try to find a solution and want to send custom mails in advance to every user, if their environment is due to be deactivated/deleted. However we cant find which information is used to determine a user activity. I cant find any property via Power Automate or PowerApps.Administration PowerShell that matches the date in the admin center.

Does anyone have some help what data could be used to achieve that?

thanks

Categories:

Governance & administering

All responses (3)

Answers (1)

Sort by

joe_hannes_col 1,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Nilsnutz,
The definition of "User activity" is somewhat vague:
"Power Platform calculates a single measure of inactivity for each Dataverse for Teams environment. The measure accounts for all activity by users, makers, and admins across Power Apps, Power Automate, Power Virtual Agents, and Dataverse.
Most create, read, update, and delete operations on the environment and its resources that a user, maker, or admin initiates are considered activity. Most read operations aren't accounted for."
Are you using the Center of Excellence (CoE)? The CoE is gathering a lot of information about the usage and resources of the Power Platform in Dataverse inventory tables. Using this information, e.g. recent launches, you might be able to construct a similar measurement for user activity.
I'm not aware of any way you can get the date Microsoft uses to determine inactivity of the environment.
Nilsnutz 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response. We do have CoE in place but are not allowed to use audit logs and have no recent usage available. I will try to setup CoE with auditing components on my development tenant and see if there is some reliable way to get those data. Maybe we can add a service account as system admin to each environment, receive that mail and use that as a trigger to send that mail to environment owners. Not an elegant solution, but the only thing I can think of right now.
Verified answer

jukka-niiranen 351 on at

Like
a
(0)

Report
Copy link

Link copied!

Today my colleague Antti Pajunen published a blog post that shows you how to retrieve the Dataverse for Teams deactivation and deletion dates via Power Automate. The information is available via the Power Platform admin connector, you just need to expand the query with "properties/scheduledLifecycleOperations".

Here's the blog post: When are my Dataverse for Teams and Trial environments expiring?

Sample solution is also available on GitHub.