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.