I am trying to create a flow to analyze a column of about 1,000 lines of text that I have in an excel file. I'm trying to do keyword extraction. I've drawn out what the flow looks like in my mind as follows:
- For each row in the column (A1, A2, A3, etc) read the excel file or CSV.
- Send that column to Text Analytics
- Write the value to B2, B2, B3, etc.
I've taken the following steps in my flow:
- Manually trigger (file)
- List Row in Column (Location = Onedrive for Business, Library = Onedrive, File = XYZ.xlsx, table = table1)
- Apply to Each - 1 (Select an output from previous steps = Excel Value), Choose an Action = Text Analysis - Key Phrases (text = Column 1 - in Table1 of XYZ.xlsx)
- Apply to Each - 2 = Select output = Key Phrases; Create a Key Column to a Table = (Same File as before but Column2 in Table1
I run that and it goes off into neverland and never actually terminates. It shows a failure for each of the 187 lines in the excel table. Does anyone have any insight on how I can get this to work?
