Answered

Get Attachments from Share Point List and use AI Builder Form Processing to read value in attachment

(0) Share

Report

Posted on by AnPhamEFL

Hi Experts,

I'm building a flow that allow user to submit attachments (PDF files) which are invoices & using an AI Builder Form Processing to get some fields in these PDF files then send an email.

i got errors in first Condition & Get File Content with below message

ActionFailed. An action failed. No dependent actions succeeded.

{
 "status": 404,
 "message": "File not found\r\nclientRequestId: 915bc000-594f-4e7b-ad1d-050a4e01e8cf\r\nserviceRequestId: 915bc000-594f-4e7b-ad1d-050a4e01e8cf"
}

The expression im using in first Condition

bool(triggerOutputs()?['body/{HasAttachments}'])

Highly appreciate any help !!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

fchopo 8,003 Moderator on at

Like (2)

Report

Hi @AnPhamEFL

A little bit difficult to inspect in detail all the actions due to image resolution... In any case, which ID are you using when getting the "Get File Content" action?

Regards,

Ferran

Was this reply helpful? Yes No
JoeF-MSFT on at

Like (1)

Report
Hi @AnPhamEFL,

Thanks for posting this question. I think Ferran is on the right path 🙂

Two things you can try, check out the screenshot below:

You can simplify the condition - no need to use an expression.

Check that you are using the rights ids for the attachment and for the list item.

Was this reply helpful? Yes No
AnPhamEFL 74 on at

Like (0)

Report

Hi @fchopo @JoeF-MSFT

Thank you for your suggestion, I just modified my flow and it ran successfully except the most important part, the AI Builder Form Processing.
I know the reason why my 2nd Condition returns FALSE but unable to resolve it, it only take the Filename with extension from When an item is created while in the sample flow created by MS named "Start AI Builder form processing when a new file is created" it take the Filename with extension from When a file is created (properties only) which is worked for me. Do you guys have any solutions ? Grateful for your helps !

Was this reply helpful? Yes No
JoeF-MSFT on at

Like (1)

Report

Hi @AnPhamEFL,

Good to see the progress!

You should use the Get attachment content action to get the content of the file to then be processed by the AI Builder action.

In the screenshot below you will see a working example. Note that I use the Process and save information from forms AI Builder action instead of Predict.

Let us know when you get it working or if you have additional questions. Happy to help!

Was this reply helpful? Yes No
AnPhamEFL 74 on at

Like (0)

Report

Hi @JoeF-MSFT,

Thank you very much for your time in helping me. I just try your solution and it works really well. I have one additional questions as below

I have the 2nd Condition which use to check if display name of attachments end with .PDF and start with Cost. Normally users will upload 2 PDF files, first is the Cost Confirmation Document.PDF for AI Form Processing another is the original invoice from supplier for Finance department. When the flow runs successfully, it returns 2 emails (picture below) one is contains 2 PDF files & text from AI Form Processing and the other is an original invoice from supplier (which does not match the 2nd Condition)

I try to put the send an email out of the loop Apply for each but it unable to get the value returns from AI Form Processing.

Is there anyway to get all type of Attachments & text from AI Form Processing in just one email. Appreciated your kind help. Thank you !

Was this reply helpful? Yes No
Verified answer

JoeF-MSFT on at

Like (1)

Report

Hi @AnPhamEFL,

You almost got it! 🙂 You need to put the three last action inside the If yes block, after the AI Builder action. That way, these action will only run when processing the document that starts with the name Cost

Was this reply helpful? Yes No
AnPhamEFL 74 on at

Like (1)

Report

Hi @JoeF-MSFT

Thank you for your help !

Was this reply helpful? Yes No