Skip to main content

EPOS for charity furniture shop SharePoint List and Power App Solution Adding stock

 


I wanted to test my SharePoint and Power App knowledge I have so far and put together a solution for Furniture Charity Shop.

So far my Data Model consists of:

9 SharePoint Lists,

2 Customized in Power App Forms ( one for adding the stock, the other as a till to sell and refund) 

2 Power Automate flows.

Adding stock adds data mainly to 2 lists: Header( StockIn) and a Split (Inventory).

To separate access for each shop I introduced folders within list, where permissions can be set individually for each shop manager / assistant and give full visibility to a general manager.


Adding Stock Template has only one screen.

Data comes from 5 Lists

I played with different controls and learnt how to use Pen Input tool to capture the signature for Gift Aided Donations

Used a lot of variables to set visibility for different parts of app and Patch() function to update weights template and add new lines, by copying  data from invoices

Power Flow moves newly created item to designated folder as per Warehouse name.

And the colour theme changes depending if it is purchased or donated goods.

The attachments can be used for any related info, for example, take a picture of collected goods, or attach an invoice or order paperwork.




Comments