PTP Fuel Consumption Management Solution

Inspiration

Chance to acquire artificial intelligence(AI) skills specifically the objection detection and text extraction model.

What it does

Applying trained AI model to identify vehicle type and vehicle number during fuel injection process.

How we built it

Trained AI model with Ai-Builder found in power automate and power apps. Created a FLOW to take photo/upload photo into -> followed by {PREDICTION} -> output predicted vehicle type and vehicle number into the database/excel file.

Challenges we ran into

Limitation on Trial licensing followed by clash with paid licensing usage. Power apps & automate accept only work or school email domain name, which poses lots of permission problem issue in {environment} setting. It also poses connection hurdle to Azure database. Hiccups when importing .csv file into MSSQL. Ai-model training errors.

Accomplishments that we're proud of

Manage to build a solution A-Z using AI-trained model and created my first MYSQL in Azure learning.

What we learned

Power automate, power apps, dataverse, azure machine learning.

What's next for PTP Fuel Consumption Management Solution

To enhance the solution with ChatGPT.

Built With

• aibuilder
• azure
• button
• dataverse
• machine
• mssql
• power-apps
• power-automate
• powerbi
• prediction