cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Can't use Run flow button and can't Test a flow

Hi, 

 

I created a flow in Excel connected with Office 365 Outlook which, when manually triggered, will send an email to a user. 

 

However, upon creating it, I tried to run it but the run button doesn't allow me to click on it. It doesn't allow me to use the test option either (see screenshots). 

 

What could be causing this situation? 

 

Thank you in advance!

 

Query.PNG

 

Query2.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

I found the issue and now it's fixed. 

 

Basically, when you finish creating your flow including giving it a name, DON'T CLICK ON THE ARROW and instead CLICK ON THE SMALL BLACK CROSS ON THE TOP RIGHT to close the flow box (see images below), SELECT A ROW IN YOUR EXCEL TABLE and then you'll see that the small triangle next to the flow you created becomes blue(see image below)  so it means it's ready to be run 🙂

 

Capture1.PNG

Capture2.PNG

View solution in original post

9 REPLIES 9
Cwaldschmit
New Member

I am running in the same type of issues.

Excel sheet with table is linked but I'm unable to run my flow

v-litu-msft
Community Support
Community Support

Hi @Anonymous and @Cwaldschmit,

 

Are you using the trigger "For a selected row" of Excel connector?Annotation 2020-09-09 111855.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Yes and my second step is just to send a email to myself with the variables from the excel sheet 

Anonymous
Not applicable

Hi @v-litu-msft

 

I'm using the "For selected row" of Excel connector indeed. 

Hello Team,

 

In that case you will not get the option to trigger the flow from the Flow environment. 

 

Whenever you use triggers like on a selected file or on a selected row the Power automate gets directly connected with the source rather than giving you the option to test manually.

 

For example, when I use trigger on a selected file as shown in the image below, the Power Automate get tied to the files in the App.

 

 

yashkamdar_1-1599635306721.png

 

yashkamdar_2-1599635328460.png

 

 

yashkamdar_0-1599635224114.png

 

 

If you want to manually trigger a flow and test you should instead use a Manual trigger and you will get the option to trigger the flow manually.

 

yashkamdar_3-1599635363459.png

 

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

 

 

 

Anonymous
Not applicable

I found the issue and now it's fixed. 

 

Basically, when you finish creating your flow including giving it a name, DON'T CLICK ON THE ARROW and instead CLICK ON THE SMALL BLACK CROSS ON THE TOP RIGHT to close the flow box (see images below), SELECT A ROW IN YOUR EXCEL TABLE and then you'll see that the small triangle next to the flow you created becomes blue(see image below)  so it means it's ready to be run 🙂

 

Capture1.PNG

Capture2.PNG

Hi @Anonymous,

 

I am glad this issue has been solved by itself, I can reproduce it and could make sure it is a temporary bug. If it still exists tommorw I will report it to MS PA development team, but there is no need to do it now, please enjoy it.

If there is any other issue occurs when you using Flow, please feedback to us, thank you very much.


Best Regards,
Community Support Team _ Lin Tu

Once i've made the flow it's not possible to add a manual trigger.

And creating it from web client is not possible the function is not there

Hello v-litu-msft,

 

I followed the mentioned solution in this post and even added a new flow. Both arrows remain gray...

 

Dendrobates_0-1619028978740.jpeg

What am I doing wrong?

 

Regards, Jeroen

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,642)