This Power Platform Solution can extract your users' Learn transcripts and save their achievements to Dataverse. If you want to read more about it please visit my blog post. This readme is focused on the installation and usage rather than the use cases.
- Premium licenses for the users, unless you modify it to save into something like SharePoint, and then only the flows need to be licensed.
- The ability to use the HTTP with Microsoft Entra ID (preauthorized) and Http Request connectors
The Solution consists of 11 objects.
- Learn Transcript Extractor App - The canvas app that enables you to provide your transcript to trigger the parent extraction flow.
- Get Microsoft Learn Data - The Power Automate parent flow that makes the API call to Microsoft Learn, provides an initial response back to the app, and fires off a child flow to process the more time-consuming element of upserting all of the data.
- Upsert Microsoft Learn Data (child) - The Power Automate child flow that makes 3 Dataverse Web API calls to upsert (update or insert) the Completed Modules, Certifications and Applied Skills from the transcript.
- MLE - Dataverse - The connection reference for the Dataverse connector.
- MLE - Http Request - The connection reference for the HTTP with Microsoft Entra ID (preauthorized) connector that calls the Dataverse Web API for your environment.
- MLE - Organization URL - An Environment Variable containing the organization URL; essentially, the website address for your environment.
- Microsoft Applied Skill - The Dataverse table for storing the attained Applied Skills.
- Microsoft Certification - The Dataverse table for storing the attained certifications.
- Microsoft Learn Module - The Dataverse table for storing the completed Learn modules.
- User - The default User table, as we save the User as a lookup in each of the above tables.
- Download the solution package. I have provided unmanaged and managed versions. Installing the managed version is useful for testing the solution as you can more easily delete it.
- Import the solution into your environment.
- When reviewing the connections, create a new connection for the HTTP with Microsoft Entra ID (preauthorized) connector and enter the environment's organization URL, like so:
- Enter the same URL for the MLE - Organization URL environment variable, like so:
That's it! Run the app, paste in your transcript, and watch the magic happen!
Open the solution and run the Learn Transcript Extractor App. Paste in your Microsoft Learn transcript share link (found from your profile) and click on 'Send transcript' for it to process your Learn data.
Once processed, you will see the statistics:
