Data source Excel or other ?

[tuonoman]

Hello everyone,
For some time I have been working on a mini ERP to manage a stock.
The database of this application is an Excel file.
It seems that this choice is apparently not the most intelligent one.
But then what should I use?

I have to :
- Manage my products
- Manage the details of my products
- Manage my stock entries and exits
- Manage the traceability of my serial numbers
- Etc.....

In your opinion, is a SharePoint list the right solution?
I'm worried about the stock entries and exits, which could generate a lot of data.

Thank you for your advice

[v-jefferni]

Hi @tuonoman ,

SharePoint could be an option, since you could store up to 30 million items/records in a single list/library.

Here is a blog introducing using SharePoint and Power Apps to manage an inventory:

https://www.aerieconsulting.com/blog/create-a-microsoft-power-app-to-track-inventory-or-equipment

And also a video which is a tutorial of "Build an Inventory Management App using PowerApps":

https://www.youtube.com/watch?v=-En6Q3i08Wc

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.