Text recognition to Microsoft list or excel

[joelrouviere]

Hi,

Is there a way to populate a Microsoft list or an excel table with text recognition?

[JoeF-MSFT]

Hi @joelrouviere - you've come to the right place 🙂 

It's definitely doable to write the results of text recognition to Microsoft List or Excel by building a cloud flow in Power Automate. Can you tell us more about the scenario you want to build so we can suggest the best approach? What type or document or image you want to extract the text from?

[joelrouviere]

Hi @JoeF-MSFT 

Thank's a lot for taking care about this question.

I have created a PowerApp that is used to enter a claim and send an automatic email to quality department.

This app is populating a Microsoft list with customer information, part number, serial number, picture of the part...

On our parts, we have the Serial Number, the Part Number and the Lot written on, and I would like to take a picture of this with a mobile and populate the fields (P/N, S/N, Lot) and autopopulate the designation linked to the P/N.

The second idea is to take a screenshot of the screen of a specific application and autopopulate an excel file with the numbers and words written on the screen (they are always on the same location on the screen, but the values changes).

The goal is to capture these values without taking to much time to enter manually in an excel file. 

[JoeF-MSFT · Accepted solution]

Hi @joelrouviere - this is great use case!

Since you already have created a Power App, I'd recommend inserting the Text recognizer component that will let you take a photo and select a text just by tapping on it. Here's an example:

Here I'm adding an action on the Serial Number text input OnSelect event to set a 'SerialNumber' variable to the text the user selects on the text recognizer control.

Last, I set the 'SerialNumber' variable to the Default property of the text input. 

When you run the app, tap a word on the text recognizer control and then on the text input and that word will get populated on the text input. Then you take the values on the text input and write them to the Microsoft List. 

I hope this gives some inspiration!

[joelrouviere]

Hi @JoeF-MSFT ,

Thanks a lot for your help!

[mobilismexico]

My Text Recognizer component does not allow me to take pictures, only choose existing pictures from local folders. How do I take the picture from the AI component?

[plarrue]

Hi @mobilismexico ,

Thanks for reaching out - Do you mean how to use the camera control to capture pictures with a device's camera ?

[mobilismexico]

• I'm going to have to take my question back. The TextRecognizer action only lets me choose a file when I execute the app in the laptop. Once I publish the app and run it in a smartphone, I can select to take a photo or choose a file.