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

AI Form Processor - Automatically Insert PDF File from Flow in PowerApp

I've been trying to create a PowerApp to process forms and take specific data fields from them. I am using a flow to find the form on Box.com and insert the PDF file into my PowerApp. I also have an AI setup to extract this data but it requires the user to find the file on the computer before scanning the document. 

 

Is it possible to link the file found on Box.com by the flow to be automatically run through the Form Processing AI on my app?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @sbeattie,

 

Can you try with the following expression? base64(outputs('Get_file_content_using_path')?['body'])

 

 

View solution in original post

11 REPLIES 11
Power Apps
Power Apps

Hi @sbeattie,

 

What you can also do is execute form processing in Flow, store the extracted fields in a datastore like CDS and retreive these extracted data in a PowerApp. https://docs.microsoft.com/en-us/ai-builder/form-processing-model-in-flow

Would this work for your scenario?

Thanks for the quick reply @JoeF-MSFT , I had previously seen the option to put the AI into a flow but was unable to find the Predict connector for processing the documents in the list of actions on Flow, as mentioned in the webpage you linked? 

Hi @sbeattie,

 

To see the predict action, you will need to create the Flow inside a solution. More info on how to do this here: https://docs.microsoft.com/en-us/flow/create-flow-solution

Great, this seems to be on the right track @JoeF-MSFT . What would the code be for passing the document into the form processor from Box.com? In the attached photo I swapped "string(triggerBody()?['file']?['contentBytes'])" for the link to the Box.com file extracted in the step above, this gave me an error?

 

 

 

Hi @sbeattie,

 

Good to see the progress! Try using the following expression: 

string(outputs('Get_file_content_using_path')?['body']) as shown on the following screenshot.
 
2019-10-17_19-20-59.png

@JoeF-MSFTUnfortunately I am still getting an error where the file is passeed to the Prediction action. This is the error message I received. I tried changiny "body" to "File_Content" but this still gave an error. 

 

"After parsing a value an unexpected character was encountered:  Path 'base64Encoded', line 19, position 44"

Hi @sbeattie,

 

Can you try with the following expression? base64(outputs('Get_file_content_using_path')?['body'])

 

 

View solution in original post

Briliant, that's got the flow working @JoeF-MSFT . Within the PowerApp, when I try to add the flow to a button I get an error Failed during http send request? 

We're almost there @sbeattie🙂

 

Are you calling the Flow from PowerApps like this, where in Flow you have a PowerApps trigger? https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Kudoed Authors
Users online (7,680)