I am working on a flow for work, and other than having no experience working in Power Automate, I am struggling at every possible step. I am using the action 'Recognize text in an image' from the AI Builder actions, trying to extract the words from an image of a label. I am using the 'Full text of the document' output from the OCR action, which returns a string, but when I try to pull any more information from there, I am being told to convert to an array, to more easily process the text. I am then running into the problem of having an array that is just one line of a long string with line breaks "\n", which means that I am only processing the whole array or the string within the array. My ultimate goal is to be able to directly take an image, extract the whole text, process it to look for specific criteria, such as the first word in all capital letters that is more than 2 letters long, a number that follows the format xxx.xxx.xx, and a number that follows the format X(Y), and take these outputs and enter them into a row in an excel table. I am using a work account, so I do not have direct access to Automate for Desktop, or all of the capabilities of Automate. I am wondering if it would just be easier to switch over to creating a process from scratch in Python or some other script.
