You’re offline. This is a read only version of the page.
2
I created multiple flows to connect to a single table and require a manual trigger. They have been working great for some time, but suddenly they all appear to be "turned off" (i.e. the "play" button is greyed out and cannot be activated).
I have checked the connections, the flow itself, and even created a new version of one and still cannot operate any. Can someone help me figure out what happened to them? Thanks!
I just had this happen to me as well, but I only have about 180 rows. I am using two tables. I updated a formula in one of may tables when it stopped working. I just discovered that (for some reason) all my flows on this spreadsheet are pointing toward Table 2, when then should be pointing to Table 1. As soon as I updated that, my "run" button worked again. Hope this helps for someone.
Wanted to post an observation that I think is applicable here. I was having an issue with the Excel selected row play button enabling per my previous post. Everything was set up properly; however, I suspected the size of the file might be hampering the activation. It was approximately 15MB, but there were about a dozen columns with vlookups and errorif formulas (multiplied by 9000 rows). After removing formulas, external references, and repasting everything as values, the buttons enabled correctly.
This is from my experience only, but I would guess that Flow can only handle a sheet with ~100-120k cells with formulas before the trigger functionality becomes hampered.
Was there any solution to this issue? I am experiencing the same problem with the play button not activating on a "For a selected row" flows within Excel. It previously took a while to activate, but now is rarely or never activates. The table size is fairly large (~8K rows), but I'm not sure if that affects the enabling of the button.
Hi @asitekedkey ,
You could try to update the username and password used when Excel online-Flow logs in.
Alternatively, you could update the connection for For a selected row.
Please take a try again.
Best Regards,
@v-bacao-msft Thank you so much for the response. Yes, I want to trigger the Flow in Excel, but the play button is inaccessible. I have tried selecting a single cell, a whole row, multiple rows, etc. and nothing is working. This is happening with all the flows I have created (probably 10-15 in two different workbooks) and happened very suddenly. I was using the flows for several months with no issues, then suddenly a couple weeks ago they all stopped working at once.
Today I tried deleting all connections and recreating them, but that didn't work either. Any other ideas?
Hi @asitekedkey ,
Could you provide more details about this Flow?
Do you want to trigger this Flow in Excel, but is play button always inaccessible?
You need to select any cell in the Excel table to run this flow, as below:
Please take a try.
Best Regards,
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
