Skip to content
Niklas Huss edited this page Feb 12, 2025 · 4 revisions

Welcome to the AI-CourseEvaluations wiki

This wiki shows how to use the SharePoint list with the Logic app to analyze text.
The list is scanned every 5 minutes by the logic app and is looking for rows with Status = New.

Input data

After importing the lists from the template files, you will have two SharePoint lists: one for Settings and one for inputting data. There are some example data which you may delete if desired.

  1. Enter data in the "Rubrik" and the "Free Text - Incomming" columns.
    Input1

  2. Set "Status" to "New".
    Input2

  3. Wait for the result, which should take at most 5 minutes. The page may need to be refreshed manually.
    Result

Analyze the data

For easier reflection of the data, a View can be created to only show the relevant data and set a filter to show only Status = Done.
ResultView

Here we can see that the first text has a overall sentiment of negative, and the sentiment score is Positive: 0, Neutral: 0, Negative 1.
The second text has a overall sentiment of positive, and the sentiment score is Positive: 0.55, Neutral: 0.43, Negative 0.02.

Flowchart

The basic flow is as seen below, if the setting UseContentSafety is Block: image

Clone this wiki locally