Skip to main content

Notifications

Community site session details
Power Automate - Building Flows
Answered

Can i extract text from an image and populate the extract data inside sharepoint

Like (0) ShareShare
ReportReport
Posted on 27 Jun 2021 12:49:48 by 3,502

Hi All,

 

I have the following scenario, but not sure How/IF i can implement it using Power Automate and SharePoint list:-

 

1) We have a club registration cards which include VIP member and Regular member.

2) the 2 cards types have different info and different layout.

3) we want to scan the documents using scanner >> upload the scanned image to SharePoint document library  >> then run a Power automate workflow which will check the image type (VIP card or Regular member card)

4) then based on this to populate the following data into a SharePoint custom list:-

 

- Content type (VIP or Regular)

- First Name

- Middle Name

- Last Name

- Registration number

- Role (Only for VIP cards)

- Member image

- Expiry date

- Issue date

- Department (Only for VIP cards)

 

 

I heard that Power automate provides an OCR capabilities, so how i can benefit from it? on the other side there is SharePoint Syntex which allow us to use AI capabilities to extract data.. so not sure from where i need to start? and which approach i can follow? Power App OCR or SharePoint Syntex and how i should utilize the correct approach?

 

Thanks

 

 

Here is a general sample of a Regular Member card:-

 

Pics2.png

  • Siddharth2 Profile Picture
    2 on 19 Mar 2024 at 08:53:44
    Re: Can i extract text from an image and populate the extract data inside sharepoint

    CAN ANYONE TELL HOW TO ACHEIVE THIS PROCESS WITHOUT USING PREMIUM ACTIONS LIKE TEXT RECOGNISER , PLEAS PLEASE HELP , PLEASE GIVE WHOLE PROCESS WITH IMAGES FOR BETTER UNDERTANDING

     

  • PrasadAthalye Profile Picture
    4,795 on 30 Jun 2021 at 15:17:29
    Re: Can i extract text from an image and populate the extract data inside sharepoint

    Form Processing works better with PDFs. I see following note so you should ensure that Images are high quality.

     

    "You can use images or PDFs of your documents to train your model, but text-embedded PDFs will provide the best results. Images should be as high-quality as possible to avoid any issues in detecting text."

     

    I would still try Text Recognizer...

  • johnjohn123 Profile Picture
    3,502 on 29 Jun 2021 at 19:50:15
    Re: Can i extract text from an image and populate the extract data inside sharepoint

    @JoeF-MSFTyes i think AI Builder Form Processing is the way to go.

    Thanks

  • Verified answer
    JoeF-MSFT Profile Picture
    on 29 Jun 2021 at 17:53:25
    Re: Can i extract text from an image and populate the extract data inside sharepoint

    Hi @johnjohn123,

     

    One way to OCR those registrations cards is by using AI Builder Text Recognizer as suggested by @PrasadAthalye. Just note that Text Recognizer will give you all the text present in the card, so you will need to a way to parse and extract the right information. 

    An easier approach can be to use AI Builder Form Processing, where you can train a custom AI model to extract the fields you want. The following tutorial will walk you how to achieve this: Get started with Form processing in AI Builder - Learn | Microsoft Docs since you have two card layouts, you will need to define two collections in your model.

    Hope this helps. Let us know how it goes!

  • PrasadAthalye Profile Picture
    4,795 on 29 Jun 2021 at 13:04:49
    Re: Can i extract text from an image and populate the extract data inside sharepoint

    Use this one ...

     

    PrasadAthalye_0-1624971876412.png

     

  • johnjohn123 Profile Picture
    3,502 on 28 Jun 2021 at 23:02:51
    Re: Can i extract text from an image and populate the extract data inside sharepoint

    @PrasadAthalye  thanks for the reply, but which ready template i need to use? is it the form processing? can you provide a screen shot?

    Thanks

  • PrasadAthalye Profile Picture
    4,795 on 27 Jun 2021 at 17:16:29
    Re: Can i extract text from an image and populate the extract data inside sharepoint

    You can use following AI Builder ready template and alter it to save the output to SharePoint List.

     

    Go to AI Builder Menu - Build and you can select Extract text from images and then select Using Flow.

     

    PrasadAthalye_0-1624814150340.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 87

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard
Loading started