Forum Discussion

ErikEastland-b9's avatar
ErikEastland-b9
Community Member
4 years ago

Java Script Help: Exporting Variables from Storyline to Excel using Power Automate

Hey all,

I am aiming to use Javascript and Microsoft Power Automate to export variables from Storyline into Excel.

I've been using this video to get me started -> https://www.youtube.com/watch?v=nPpjfW-Zo10&t=98s

So far, the flow I made in Power Automate has not triggered. I assume that means there is a problem with the Javascript code in Storyline that is preventing it from sending the HTTP request to trigger the Power Automate flow. Can a kind soul check out my Javascript code and confirm that it does what I need it to do? I am happy to provide additional information if needed.

  • Problem solved! I assumed that the "Numeric Entry" input would produce an integer variable, but java was picking up the variable as a string.

    After changing the schema in Power Automate from integer to string for that variable, it worked flawlessly!

    Edit: Use 'number' instead of 'integer' if your variable could be a decimal

  • Really nice workflow. Looks interesting.

    Tried it and alas is HttpRequest blocked in Sharepoint at our university.

    • TeresaTierney's avatar
      TeresaTierney
      Community Member

      Blocked for me too. .. Let's request a storyline connector for Power Automate! 

  • I wanted to try this today as well since I have a case where I need to capture some variable outside of an LMS.  My problem is this flow contains a premium feature.  Not sure if it was $$$ when the recording was made.  Appreciate the whole idea and share here though.

  • JoshuaThian's avatar
    JoshuaThian
    Community Member

    Hi all,

    Followed the youtube guide posted above and managed to get it to work.

    Now the next step i am considering is how to import variables from excel into storyline.

    Do i still use power automate? I am at a loss of how to do it.

    Any help would be appreciated.

     

    Thank you.