Flow no longer appears in Excel file

(0) Share

Report

Posted on by dj crowley

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.

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

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

Categories:

General topics

All responses (6)

Answers (1)

Sort by

Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

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 !
CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

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 !
CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

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 !
dj crowley 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, this got me back on track! You were right, the parameters were not correct.
/djcrowley
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
dj crowley 15 on at

Like
a
(0)

Report
Copy link

Link copied!

My bad! thanks