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.
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
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.
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 ๐
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 ๐
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! โ๐บ
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,079
Most Valuable Professional