Likert data not copied to Sharepoint List

(0) Share

Report

Posted on by SandhamJ

I have a flow that I've built to combine data from multiple excel files into one Sharepoint List.

The flow is manually triggered and has a condition - if the file name in a specific folder contains "Course Evaluation", the data needs to be copied into the sharepoint list.

Everything is working fine, except when it comes to the likert data. The scale is a 5-point scale - "Strongly Disagree" to "Strongly Agree". Even though the data is visible as text in the excel file, the data is not being copied across to the Sharepoint List.

How can I get the flow to copy the text that has been saved for the likert questions in the excel document into the Sharepoint list?

Screenshot 2022-05-03 at 16.06.36.png Screenshot 2022-05-03 at 16.07.27.png