No video
How to send any data from an Articulate Storyline E-learning to Microsoft Excel using Power Automate
In this video, I will demonstrate a use case for Microsoft Power Automate. I will show you how to send learner data from an e-learning course created using Articulate Storyline to an Excel file hosted in a SharePoint Online site. This is usually done using xAPI but using Power Automate is a much easier option. To do this, I will be creating a new Power Automate flow using the HTTP action.
I have added the JavaScript code that I have used in the Storyline trigger in the link below.
instinctive-ap...
Please comment if you have any questions or comments. I will be checking the comments off and on.
Пікірлер: 21
I think this solution should theoretically work, but I couldn't make it work. I realized that the authentication prompt is blocking the parse to Excel. I did a quick inspect elements on the SL results page and saw a 401 error associated with that. Then I reasoned, in the Power Automate's HTTP field, if you set "Who can trigger the flow" as "anyone," it should work....But it still didn't, making me think the org also doesn't allow that. Is there a way to solve this issue?
Awesome video mate. Can this be other way around, I have a requirement, where on the submission of SharePoint record, I have to update the variable in StoryLine for the particular learner course.
@techminds9024
2 жыл бұрын
Sorry; saw this comment late. You can use the SharePoint actions available in PowerPoint to monitor changes and send in HTTP requests. However, the Storyline content should be hosted in an API environment, that is a site that can send and receive HTTP requests.
First off, thank you for sharing. This is very similar to the using xAPI statements. Have you figured out a way to access stored data in excel from storyline/LMS and based on that data determine the learning experience designed for the module? For example, if a learner has completed learning experience 1, then in experience 2 the learner would have a shortened pathway and not have to cover similarly related content to experience 1.
Hi thanks very much for the tutorial. Quick check - does this method works if a client wants to host their Storyline course on their SharePoint Intranet as a html file? Thanks very much!
@5:53 in the video, you copy the schema into the Parse JSON step, but *Content is not selected. It's required, so which option do you choose?
I'm wondering if I need to change the name of my variables to "nameSL", "emailSL", "scoreSL", etc because I've followed every step in your video and can't get the information to show up in the spreadsheet I created. I don't know what I'm doing wrong. Any suggestions? From anyone?
This method looks really promising! I haven't been able to get the power automate to trigger yet. Question 1: If I have more than 4 variables, do I have to change the 4 in line 16 of your code to the number of variables I am pulling? Question 2: the code you put in the description is missing lines 30 and 31 (console.log lines). Is that on purpose? Thanks!
@Doublee73
2 жыл бұрын
I figured it out. You do not need to change the 4 if you have more or less variables The lines in 30 and 31 are not necessary, but they're extremely helpful in troubleshooting issues
@techminds9024
2 жыл бұрын
@@Doublee73 Saw this comment late; glad that you figured it out 🙂
@Doublee73
2 жыл бұрын
@@techminds9024 yeah I didn’t realize that number entry inputs are set as a string and not an integer. Also you need to use number instead of integer if your variable is computed as a decimal
I can't get more variables to work - is there something in the code that needs changing? once I go over three varaibles I can't get it to work - delete the forth variable and the code goes through perfectly. Am I missing something?
I've been successfully using the method of pushing data to Google Sheets for some time now, but my institution's ethics board has pushed back on it. They want the data to be pushed to Excel, instead. This method would be the ideal solution ... if I could get it to work. I'm two hours in, and nothing. I'm not sure at what level it's going wrong - and I'm only trying to replicate your exact variables, code, etc. For one, 'integer' doesn't appear instead of 'string', but it could also be that I'm not doing the JSON correctly in the first place. I'm also wondering if you've done anything about your 'time' variable in Storyline that isn't shown here.
@techminds9024
2 жыл бұрын
Can you console.log and let me know the time format that you are sending to Excel? Needs clarity on integer vs string
@lyndsayolson6228
2 жыл бұрын
@@techminds9024 I put in JSON.stringify({a:new Date{}}) and the output was '{"a : "2022-03-07T10:21:56.750Z"}' if that's of any use. I can get it to capture text that is typed into a text entry box. But I cannot get it to capture a variable that I set (e.g. set variable 'question1' to value 'A' when the user clicks radio button1. In which case I'm simply adding 'question1' as a variable just like 'name' and 'email' (which do work for me, the text input works fine).
@lyndsayolson6228
2 жыл бұрын
Actually ... I don't know what I've done differently - but I've got it working now.
Hi How to send the result of student to excel in the same computer of student
Hello Sir! I wanna ask something. Is it means that students access and do their quiz in online way? Is it possible if they do it while offline and their score still recorded in spreadsheet?
@techminds9024
2 жыл бұрын
Yes, the content need not stay online but obviously, there should be a network connection in the laptop.
@ikeh.9272
2 жыл бұрын
@@techminds9024 Thank you, Sir! The laptop must have an internet connection starting when students take their quizzes or only when they will send their grades to the server, Sir?
@techminds9024
2 жыл бұрын
@@ikeh.9272 Whenever you are sending across the API call, in the above case it's when the grades are sent.