cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JohnEdward
Frequent Visitor

Need Admin Approval Excel Online -

Need Admin Approval Excel Online.

When using Excel Online in MS Flow, it prompts a sign in and upon signing in it says that "Needs Admin Approval, Excel Online"

Please see below screenshot.

Please help.

Capture.PNG

11 REPLIES 11
Community Support
Community Support

Re: Need Admin Approval Excel Online -

Hi @JohnEdward,

 

The error message told that the Excel online needs permission to access resources.

 

Please check if your connection account have the permission to access resources.

And if your connection account don't have the permission to access resources,please ask the admin to grant permission.

 

Best regards,

Alice

JohnEdward
Frequent Visitor

Re: Need Admin Approval Excel Online -

Hello 

DavidLozzi Advocate II
Advocate II

Re: Need Admin Approval Excel Online -

Any progress on this? Having same issue and would LOVE to use this action.

Lozzi
slalom
Highlighted
KaineVarley
Frequent Visitor

Re: Need Admin Approval Excel Online -

Any progress? I'm experiencing the same issues...

KaineVarley
Frequent Visitor

Re: Need Admin Approval Excel Online -

I believe that have solved my problem. There are two types of Excel Online; Business and OneDrive. The issue I was having, as described above, was because I was trying to use the OneDrive version rather than the Business version. The Business version seems to work fine.

 

Kaine

2019-05-01_1145.png

bmurphy1 Helper II
Helper II

Re: Need Admin Approval Excel Online -

I'm trying to use this and connect it to OneDrive.  What admin privileges do I need?

team_user
Frequent Visitor

Re: Need Admin Approval Excel Online -

I am getting the same error message "Need Admin Approval".   And yet I am an owner have Full Control access of my site.  Why would "admin access" be required?  

KaineVarley
Frequent Visitor

Re: Need Admin Approval Excel Online -

Hi @team_user,

 

Have you tried Excel Online (Business) instead of Excel Online (OneDrive)?

 

See my post above.

 

- Kaine

team_user
Frequent Visitor

Re: Need Admin Approval Excel Online -

Yes, I tried both Excel Online and Excel Onedrive

bmurphy1 Helper II
Helper II

Re: Need Admin Approval Excel Online -

@KaineVarley 

 

Business forces me to use an excel sheet on SharePoint.  I need to use one on OneDrive.

Community Support
Community Support

Re: Need Admin Approval Excel Online -

this is a consent issue, please work with the tenant admin to check if the “Users can consent to apps accessing company data on their behalf” option in AAD is set to YES. This option can be found under Azure Active Directory >> Users and groups >> User settings >> Enterprise applications.

If this is set to NO, you'll need to work with the tenant admin to ok the usage of this connector for the tenant. Once that is done, you'll be able to use it without it asking for additional permission. The tenant admin, will need to create a connector using this connector and approve it. 

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (7,692)