Microsoft Secure Tech Accelerator
Apr 03 2024, 07:00 AM - 11:00 AM (PDT)
Microsoft Tech Community
SOLVED

AAD | Enabling excel online connections from power automate

Brass Contributor

Hi,

 

I am a o365 tenant admin and have given some users power automate free licensing.

When they try to connect to excel online (onedrive) from a PA flow, they receive an error saying they need admin approval to access the resources.

I assume this setting is enabled in the AAD portal but I couldn't find any such setting (it would be great this could be done on a user basis and not org wide).


Can anyone help?

 

Thanks/Brgds

joao

1 Reply
best response confirmed by Joao Casqueiro (Brass Contributor)
Solution

@Joao Casqueiro 

 

Hi, @Joao Casqueiro.

 

You might have more luck asking in a Power Automate-related forum - even though the settings are found within the Azure AD Portal.

 

First, even though it's dated, this is still relevant advice:

 

 

With respect to where to find the user approval settings, the location has changed a little, so here's two screenshots to get you into the right location.

 

A tenant administrator will need to make any relevant changes here for you, and they really need to understand the implications of each settings. You don't want your organisation being the next ransomware victim (or anything else of a similar nature.)

 

LainRobertson_1-1685619542113.png

 

LainRobertson_2-1685619555434.png

Cheers,

Lain

1 best response

Accepted Solutions
best response confirmed by Joao Casqueiro (Brass Contributor)
Solution

@Joao Casqueiro 

 

Hi, @Joao Casqueiro.

 

You might have more luck asking in a Power Automate-related forum - even though the settings are found within the Azure AD Portal.

 

First, even though it's dated, this is still relevant advice:

 

 

With respect to where to find the user approval settings, the location has changed a little, so here's two screenshots to get you into the right location.

 

A tenant administrator will need to make any relevant changes here for you, and they really need to understand the implications of each settings. You don't want your organisation being the next ransomware victim (or anything else of a similar nature.)

 

LainRobertson_1-1685619542113.png

 

LainRobertson_2-1685619555434.png

Cheers,

Lain

View solution in original post