web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : PQtHOzOsWNXOBeJ2dz17w2
Power Automate - Using Flows
Answered

excel flow

Like (0) ShareShare
ReportReport
Posted on 27 Jul 2018 21:36:18 by

I have many Excel worksheets in Sharepoint. I am trying to implement a flow to do an email notification. It is working in my first Excel worksheet. In my next Excel sheet, when I click on Flow in the Excel On Line, the flow panel opens. But, instead of displaying the flow I created, it says "Create your first flow" - so why dont I see the flow I already created? 

 

Also - on a second comupter I can open the same worksheet. When I say to edit in Excel and I click on Flow, then the panel opens but it never populates and I hear a click, click click, click, click...

  • Verified answer
    Community Power Platform Member Profile Picture
    on 28 Mar 2019 at 23:24:44
    Re: excel flow

    I did come up with a flow that runs off excel the way I wanted: It triggers an email notification based on a change to an excel file in SharePoint. It uses excel on SharePoint, vba macro to transfer data into a “master” excel file on shared network drive, which is synchronized to a SharePoint list which THEN triggers the email in flow when a new row arrives to the SharePoint list.

     

    Feels a little “work-aroundy”, but it seems to be functional.

     

    The initial approach wasn't workable b/c each separate excel sheet would be linked to each flow, the path/file gets some digital tokens that tie them together. So I abandoned the whole idea for awhile. Then I re-thought the process and came up with this approach.

  • Community Power Platform Member Profile Picture
    on 28 Oct 2018 at 17:51:31
    Re: excel flow

    I see in settings a reference to my Excel file:

     

    1. Location (readable URL)

    2. Document Library some odd code: b!ZFHrYtYJ5UOBWU_X... 65 characters

    3. File another odd code 01U7T73... 34 characters

    4. Table

     

    So if I can figure out the odd code for all my Excel sheets in SharePoint could I modify the Document Library and the File so that the Flow could then be used over in other Excel sheets without having to re-create the flow for every separate Excel sheet? (There are hundreds of these sheets to run this Flow on). 

     

    Like with VBA or within the Flow? 

  • Community Power Platform Member Profile Picture
    on 05 Aug 2018 at 06:05:08
    Re: excel flow

    Is it necesary to create a new flow for each separate Excel file that is in the Sharepoint directories? I would like this flow to execute for any Excel file in the Sharepoint directory as long as it contains a table called Table1 and the flow can run.

  • Community Power Platform Member Profile Picture
    on 05 Aug 2018 at 06:02:34
    Re: excel flow

    Capture2.JPG

  • v-yamao-msft Profile Picture
    on 31 Jul 2018 at 05:50:45
    Re: excel flow

    Hi @Anonymous,

     

    How is your flow created? Could you show me a screenshot to help reproduce this issue on my side?

     

    I assume that you are using the Excel online trigger For a selected row, is it right?

     

    You said that in your next Excel sheet, you are asked to create your flow. Have you created a flow for this Excel file?

     

    Please share more details to help reproduce this issue.

     

     

    Best regards,

    Mabel Mao

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete