Extracting comments from an Excel spreadsheet to be ran through sentiment analysis.

(0) Share

Report

Posted on by Community Power Pla...

Hi Everyone,

I apologise if this is a basic question as I am still fairly new to building flows with power automate. I am currently trying to write a flow which can extract a column of comments from an excel spreadsheet, run each one through both a sentiment analysis, and key data extraction AI module, before finally inserting the resulting key words and positive/negative data into an excel spreadsheet.

So far I have built a functioning manual flow following a Microsoft tutorial to create the flow seen below, the main issue with this is the fact it requires the manual entry of comments, which is not feasible with a large ammount of data.

Following this I attempted to add the excel data extraction using both the list rows in a table and get a row commands, however, this resulted in the following error.

Error Code.PNG