Device and Matarial ordering app

Like (0) Share

Report

Posted on 13 Sep 2021 12:30:20 by Tahir2132

Hello Everyone, I have this simple Excel Table i would like to create an app from.

My goal is to create an app for the employees, to be able to order The teams from this list using the app.

They should be able to select multiple Items to order and submit it .

After its submitted a flow should be created the email will go first to the department manager for approval if approved then the order should go to purchase department for future process.

my first goal is to create this app then the flow

Thanks allot

All responses (3)

Answers (1)

Tahir2132 68 on 14 Sep 2021 at 06:30:39

Like (0)

Report

Re: Device and Matarial ordering app

thanks men your the best a true hero
Verified answer

StalinPonnusamy Super User 2024 Season 1 on 13 Sep 2021 at 23:58:13

Like (1)

Report
Re: Device and Matarial ordering app

Hi @Tahir2132

As Bryan mentioned, the list you showed is a Master list of products.

1. PowerApps
Insert gallery on the screen and set Items property to Excel Table
Design Gallery as Table formatted like below

Set Onselect property of Save button/Icon to
ForAll( Filter( GalleryProducts.AllItems, Value(QtyInput.Text) > 0 ), Patch( DeviceOrdering, Defaults(DeviceOrdering), { Title: ProductName.Text, Description: ProductDesc.Text, Qty: Value(QtyInput.Text) } ) )
Note: These always create new entries. We need to change if the user needs an update.

2. Power Automate
Create flow whenever a new item is created
We have Action/Step to send approval
BCLS776 8,988 Moderator on 13 Sep 2021 at 13:27:22

Like (0)

Report

Re: Device and Matarial ordering app

@Tahir2132 , I didn't see a specific question in your post, so I'll offer a few suggestions. Your excel list will make a good set of items from which to order, but you should have another table that captures order details, including a list of items that form part of the order. Also, a Sharepoint list is a much more performant choice for Power Apps, so use those if you can.

After that, yes a flow that creates an approval is one way to handle the orders. After that, what do you plan to do with the orders?

Bryan