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)

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