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?

Report
All responses (
Answers (