How is it working?
To track my personal expenses throughout a month, I have created a simple web form with Vue.js and Vuetify and the Azure Storage JavaScript Client Libraries. It is hosted on an Azure static web site.
On save, the entry is stored in an Azure storage queue.
From there I have created a Flow to append the data to an existing Excel sheet hosted on SharePoint Online.
Add some (pre-built) machine learning to it
Microsoft just launched the private preview to understand receipts with Form Recognizer.
So to make it even easier to enter new receipts, I have added a capture button to my web app to make a photo from the receipt and send it to the Form Recognizer API.
The API returns a JSON response with fields for Total
, MerchantName
, TransactionDate
, and a lot more. I grab them and populate the input fields.