cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Save email attachment in sharepoint, OCR the attachment if its an image, update a column on the file

Hi there,

 

I was hoping someone might be able to point me in the right direction for a task i'm trying to create in Flow.

 

We would like to scan images to an email address

When an email is received, Flow should save the attached image in Sharepoint

Flow should then OCR the image and find a specific string of text and numbers after it i.e. "Invoice: 99999999"

Flow should then alter the file saved earlier to add the returned string to a specific column i.e. "Invoice No".

 

I can get Flow to create the file from one of the templates that i've modified slightly, however the pieces i'm missing are 1) letting the OCR (Computer Vision) know the location of the image to scan, 2) searching for the specific string of text and storing it in a variable, 3) getting the file from earlier, 4) updating the file from earlier with the text returned from the OCR step.

 

If anyone could point me in the right direction for the steps i believe i am missing, or perhaps a better flow entirely to complete the task that would be fantastic!

 

If there are any more details that would be useful to know please shout up and i'll gladly provide what i can.

 

Many thanks in advance!

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Save email attachment in sharepoint, OCR the attachment if its an image, update a column on the

Hi @callum_williams

 

Could you please expalin more about the OCR that you mentioned.?

Could you please share a screenshot of your flow and share more details about your trouble when achieve your requirement so we would try to provide a proper workaround for you.

 

Best regards,

Alice

Highlighted
Regular Visitor

Re: Save email attachment in sharepoint, OCR the attachment if its an image, update a column on the

Hi Alice,

 

Here is a link to the Azure Computer Vision app: https://azure.microsoft.com/en-gb/services/cognitive-services/computer-vision/, you create it as a resource in Azure and then use the keys to link Flow to it.

 

I've got a screenshot of the entire flow but its quite large so here's a link: https://ibb.co/Jd7SqCC

 

The error happens at the "Optical Character Recognition (OCR) to Text" step,

 

Here is the full image code:

 

{
  "@odata.type": "#Microsoft.OutlookServices.FileAttachment",
  "Id": "AAMkADExYzZhYzRmLWIwN2YtNDBmMi04NDk5LWQ5NTMwOWQ1MzExYwBGAAAAAAAkPObnF1jISL7uUQBXDG2WBwA0JXmDeNHnSLA-22eXJQEVAAAAAAEMAAA0JXmDeNHnSLA-22eXJQEVAAGlth_bAAABEgAQAHHfU0L9pIFItfZF82-qNYQ=",
  "Name": "B001FTFR.TIF",
  "ContentType": "image/tiff",
  "Size": 143247,
  "ContentBytes": "SUkqAHwUAgD/2P/AAAsIYTuoHwDFU4W/Nrrt55/2GKEAHQAA"
}

Here is the body from the error:

 

{
  "code": "BadArgument",
  "requestId": "6e6cf510-e3d4-4aa8-af03-8910428a4887",
  "message": "JSON format error."
}

Many thanks

Callum

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,876)