Access users OneDrive for Business

[DavidVM]

Hello

Because of the introduction of Auto-Expiration for Teams Meeting Recordings we would like to set-up a Power Automate Flow.

In this flow we would like to access all users OneDrive libraries and check if there are any recordings older than e.g. 46 days. If that is the case they should get an email that warns them that these files will be deleted in 14 days.

Is there a way to realize this with Power Automate? I can set it up for my personal account, but it looks like I can't access other users account (with our admin account).

Is this true? And is there another solution available?

Kind Regards

David

[eric-cheng · Accepted solution]

Hi @DavidVM ,

The challenge you will have is that the OneDrive connector does not return Created Date and there is only Modified Date.  This might be ok if the file hasn't been modified.  Similarly, I am not sure of is whether you will be able to access someone's OneDrive via the connector even if you have been delegated access or granted global admin (haven't tried).

An alternative is to use Graph.  You can get a user's OneDrive here and then to search files here or list files here. 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[DavidVM]

Maybe the use of Graph is indeed the solution. I'm afraid that's something I will have to ask someone else to implement. Because of being a more technical approach. In the meantime I will consider this topic as closed. Thanks.

[francis17]

Hi @DavidVM,

did you get a solution working for your situation? I'm looking for something similar (check if the users have files last modified a year ago in their ondrive, email them the list of files to tell them the files will be deleted..)

I'm able to gather the oneDrive url for each user using "Get user profile" / "My Site" but cannot use it as a OneDrive path (that would have been too easy I guess...). I'll check if I can do something with Graph, but it sounds like a great journey. 

Thanks

Francis