Create an application using receipt processing

(0) Share

Report

Posted on by ppblab77

hello

I am somewhat new to power apps, but not to 365.

I am trying to create an application with which I can take a photo of a ticket and that this photo is stored in a library and its table in a sharepoint list.

To achieve this I see two options.

1 option. this option follow this thread
https://www.c-sharpcorner.com/article/receipt-processing-using-ai-builder-in-power-apps/

I have a problem in Step 4, when I want to enter the code in the "OnChange" section I get an error in each ";"

I don't understand why the code doesn't accept me.

I don't understand why this happens to me.

2 option. following a link from microsoft.

https://docs.microsoft.com/es-es/learn/modules/ai-builder-receipt-processing/3-create-app

In this case I don't know how to create a button to save this information in my library and sharepoint list. I imagine that with some flow and capturing the information, but I can't continue with this option either.

I would greatly appreciate the help.

I intend to save the image in this library with these extra columns and the table in a list (creating one record per line of the table).

library structure

list structure

Categories:

AI Builder

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

JoeF-MSFT on at

Like (3)

Report
Hi @ppblab77 - welcome to Power Apps! 🙂

@RezaDorrani has this great video that explains how to build an expense reporting app including the AI Builder Receipt Processing module: PowerApps Expense Reporting with Receipt Scanning AI - YouTube

A possible approach to your use case is indeed by calling a flow from your app that can upload the receipt along the extracted data.

1. Here is how your flow should look:

A few things to mention:

For each field you want to send from the Power App, select the following option in the flow: Ask in PowerApps

For the file name in the SharePoint Create file action, I used the following expression:

concat(utcNow(),'.jpg')

And for the File content the following expression. Note, first I wrote the expression dataUriToBinary() and then I switched to the Dynamics content menu to select 'Ask in PowerApps' to have triggerBody()['Createfile_FileContent']

dataUriToBinary(triggerBody()['Createfile_FileContent'])

2. Once the Power Automate flow is ready, go back to the app, select the button that you inserted and go to the Action menu > Power Automate > and select the flow you created.

3. Complete the formula so you send all the info to the flow. Make sure you are adding this on the OnSelect property of the button you have added to your app.

4. Run the app, upload a Receipt, select the save button and the information will be sent to the flow that will save all the information to SharePoint!

I hope this helps! ☕🍺

Was this reply helpful? Yes No
ppblab77 26 on at

Like (0)

Report

hello friend, this really helped me!

I am very grateful to you, my progress has been very remarkable, thanks to your personalized comment.

I have already managed to add the analyzed images to my library.

@JoeF-MSFT Allow me one more question. I would also like to capture the table and this in turn create an element for each line of the table in a sharepoint list.

List
(I usually match the items in the list with the file id of the library)
app

----
As a curious fact, in my code I must put ";" where you put ","... I don't understand why, it must be the language or something.

I repeat, thanks for the help, I owe you a coffee 😊

Was this reply helpful? Yes No
ppblab77 26 on at

Like (0)

Report

hello again friend.

Finally managed to insert the ticket table in another separate list.

I introduce the purchased items table in a variable with json. Then I add this to the button call and then to the flow. compose -> parse json -> apply to each in outputs -> create item

I had to use two buttons. 1 for the variable and 2 for the flow call, I still have very strange errors when joining several formulas.
I don't understand what problem my power apps has with ";" and ","

so if it works

button 1
button 2

It does not work like this

in various formats the formula
neither using : nor .

I don't know what the problem will be. We keep working 😁

Was this reply helpful? Yes No
ppblab77 26 on at

Like (1)

Report

using ";;" It is the solution to my problems
.

Thanks @JoeF-MSFT !!! 😁😉

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

Like (1)

Report

Congratulations @ppblab77! And thanks for sharing the steps you followed. When we go for that coffee ☕, we'll be able to use your app to do expense reporting. 😊

You know where to finds us in this forum if you have any additional AI Builder question.

Was this reply helpful? Yes No