Can't sign into Flow/Power Automate in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2438969%22%20slang%3D%22en-US%22%3ECan't%20sign%20into%20Flow%2FPower%20Automate%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2438969%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20help%20a%20colleague%20build%20a%20flow%2Fpower%20automate%20system%20in%20an%20excel%20sheet%20using%20the%20Flow%20automation%20add-in%20that%20is%20found%20in%20the%20Data%20Tab%20on%20the%20ribbon.%26nbsp%3B%20%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EFirst%20problem%3A%20in%20the%20desktop%20version%20of%20excel%20the%20Flow%20automation%20button%20appears%20on%20the%20data%20tab%20for%20the%20user%2C%20but%20when%20the%20user%20tries%20to%20sign%20in%20via%20the%20box%20that%20pops%20up%20nothing%20happens%20after%20their%20details%20have%20been%20correctly%20entered.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ESecond%20problem%3A%20When%20the%20user%20opens%20excel%20online%20in%20their%20browser%20(Edge%20in%20this%20case)%20the%20flow%20automation%20button%20that%20should%20be%20appearing%20in%20the%20data%20tab%20is%20missing.%20Does%20anyone%20know%20of%20a%20way%20to%20make%20the%20flow%20button%20appear%20in%20excel%20online%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DataFailure_0-1623409086073.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F288059i41010EEA50BB4F12%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DataFailure_0-1623409086073.png%22%20alt%3D%22DataFailure_0-1623409086073.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E(image%20is%20from%20my%20browser%20where%20the%20app%20is%20appearing%20as%20it%20should)%3C%2FP%3E%3CP%3EIn%20the%20past%20when%20I%20have%20had%20trouble%20signing%20into%20PA%20in%20Excel%20desktop%2C%20I%20have%20opened%20up%20excel%20online%2C%20signed%20into%20flow%20there%20which%20has%20kicked%20PA%20in%20excel%20desktop%20to%20signing%20in%20as%20well.%20Since%20my%20colleague%20is%20missing%20the%20flow%20button%20on%20the%20excel%20online%20ribbon%20I'm%20stuck%20on%20how%20to%20help%20them%20further.%20This%20user%20does%20have%20access%20rights%20to%20PA%20and%20has%20no%20trouble%20signing%20in%20to%20to%20see%20their%20flows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2438969%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2489265%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20sign%20into%20Flow%2FPower%20Automate%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2489265%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1052839%22%20target%3D%22_blank%22%3E%40DataFailure%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20Problem%3A%20try%20activating%20power%20automate%20via%20the%20web%2C%20or%20just%20uninstall%20the%20add-in%20and%20install%20it%20again.%3C%2FP%3E%3CP%3ESecond%20Problem%3A%20Go%20to%20Excel%20Online%20Add-in%20and%20remove%20the%20plugin%20in%20and%20add%20again.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20to%20mark%20it%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more.%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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? 

DataFailure_0-1623409086073.png

(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.

 

 

 

 

1 Reply

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.