cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
djcrowley
New Member

Flow no longer appears in Excel file

I'm a novice, Jim.

I created a very simple flow in an Excel file last week.  It worked.  

Today when I open this same Excel file and click on the Flow button on the Data tab, it says "You don't have any flows for this file".  This is where the flow was listed last week, but it's gone.

djcrowley_0-1663686648364.png

 

But I found the 'Manage your flows' page for Power Automate, and the flow is still listed (it's called 'Add to listservs' in the screenshot below.). 

djcrowley_1-1663687237833.png

(note: the Environment is obscured so I don't embarrass my employer.  But there is only one environment, and I am in it.)

 

One question is:

How do I add this flow to my Excel file?  

Another question is,

Why did this flow disappear from my Excel file?

(and how can I avoid that in the future).

 

For background: (1) I tried opening the file in both the  Desktop and Online versions of Excel, and the flow isn't in either one. (2) I'm using an "Enterprise" license of some kind, for all O365 products. (3) I'm logged in to the same account in every context; I only have one account.

In lieu of a solution, I'd like a pointer to an explanation of where Flows live and how they are associated with individual Office files.  What is 'instant' flows? Etc.

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Dual Super User
Dual Super User

@djcrowley ,

1.

If you see the flow in Power Automate then there is not a big problem. All you need to do is to access the flow in edit mode and check the trigger. One of the parameters is altered. Set the parameters to point to your file and your table.   

 

gabibalaban_0-1663694621386.png

 2. The cause is most probably connected to a insignificant (for you) change of the file / table (table rename, table deleted and recreated). 

Hope it helps !

View solution in original post

6 REPLIES 6
gabibalaban
Dual Super User
Dual Super User

@djcrowley ,

1.

If you see the flow in Power Automate then there is not a big problem. All you need to do is to access the flow in edit mode and check the trigger. One of the parameters is altered. Set the parameters to point to your file and your table.   

 

gabibalaban_0-1663694621386.png

 2. The cause is most probably connected to a insignificant (for you) change of the file / table (table rename, table deleted and recreated). 

Hope it helps !

gabibalaban
Dual Super User
Dual Super User

@djcrowley ,

1.

If you see the flow in Power Automate than there is not a big problem. All you need to do is to access the flow in edit mode and check the trigger. One of the parameters is altered. Set the parameters to point to your file and your table.   

 

gabibalaban_0-1663694621386.png

 2. The cause is most probably connected to a insignificant (for you) change of the file / table (table rename, table deleted and recreated). 

Hope it helps !

gabibalaban
Dual Super User
Dual Super User

@djcrowley ,

1.If you see the flow in Power Automate then there is not a big problem. All you need to do is to access the flow in edit mode and check the trigger. One of the parameters is altered. Set the parameters to point to your file and your table.   

 

gabibalaban_0-1663694621386.png

 2. The cause is most probably connected to a insignificant (for you) change of the file / table (table rename, table deleted and recreated). 

Hope it helps !

djcrowley
New Member

Thanks, this got me back on track!  You were right, the parameters were not correct.

/djcrowley

@djcrowley ,

It really helps other users with a similar problem as yours, if you accept one of my posts (strange behavior 3 identical posts) as solution. 

 

djcrowley
New Member

My bad!  thanks

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,562)