I have an AI model in power automate which reads text from a PDF. The text that is read are the various strengths the person has. See picture for example.
The text is then entered into a spreadsheet.
However, the individual strengths are picked up as a string rather than separate items. The string is entered into one excel cell and then I manually split text to columns as I want each separate strength to go into a separate column.
I want to incorporate the splitting into my flow. I have successfully split this into an array using split function. The problem is that the arrays are variable lengths as different people have different number of strengths.
How can I check the array length and then add the separate items into excel columns based on the number of items in the array?
Thank you!!!
