Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Governance and Administ...
Answered

Get inactive dataverse for teams environments with power automate

(0) ShareShare
ReportReport
Posted on by 36

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:
  • Verified answer
    jukka-niiranen Profile Picture
    351 on at
    Re: Get inactive dataverse for teams environments with power automate

    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.

  • Nilsnutz Profile Picture
    36 on at
    Re: Get inactive dataverse for teams environments with power automate

    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.

  • joe_hannes_col Profile Picture
    1,843 Super User 2024 Season 1 on at
    Re: Get inactive dataverse for teams environments with power automate

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Apps Governance and Administering

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 9 Super User 2025 Season 1

#2
bscarlavai33 Profile Picture

bscarlavai33 5 Super User 2025 Season 1

#3
getsplash Profile Picture

getsplash 2

Overall leaderboard

Featured topics