Forum Discussion
Can't sign into Flow/Power Automate in Excel
Hi,
I'm trying to help a colleague build a flow/power automate system in an excel sheet using the Flow automation add-in that is found in the Data Tab on the ribbon.
First problem: in the desktop version of excel the Flow automation button appears on the data tab for the user, but when the user tries to sign in via the box that pops up nothing happens after their details have been correctly entered.
Second problem: When the user opens excel online in their browser (Edge in this case) the flow automation button that should be appearing in the data tab is missing. Does anyone know of a way to make the flow button appear in excel online?
(image is from my browser where the app is appearing as it should)
In the past when I have had trouble signing into PA in Excel desktop, I have opened up excel online, signed into flow there which has kicked PA in excel desktop to signing in as well. Since my colleague is missing the flow button on the excel online ribbon I'm stuck on how to help them further. This user does have access rights to PA and has no trouble signing in to to see their flows.
Hi DataFailure,
First Problem: try activating power automate via the web, or just uninstall the add-in and install it again.
Second Problem: Go to Excel Online Add-in and remove the plugin in and add again.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget to mark it as Official/Best Answer & like it to help the other members find it more.
- sreejith_123Copper ContributorThis happened due to recent update of either your browser or windows. Please open the excel document in excel app (not web). This solved my problem.
- london690Copper Contributor
This is occurring for me as well.
I can't find a solution anywhere online.
Any ideas of what to do yet? Did you get it sorted?
Thanks so much in advance!
Initial question is 3 years old, lot of changes from that time. Do you mean you can't initiate Automate Work in Excel Desktop for Windows?
- semichiCopper Contributor
What license is needed if the Automate work button is grayed out in Excel desktop? Is it available on the web only? I have a user who has Power Apps Premium and Power Automate per user plan.