cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sai007
Level: Power Up

Item Quantity Added & Quantity Requested Fields

Hi,

 

1) We have built a PowerApp app for our Purchasing team. The app allows users to add excess items by filling the below form .  As soon as user submit the form, this item will be added on the home galleryAdd Item Screen.pngAdd Item

2) Other hospital user can click on the required item in the home gallery, where it open the another screen with the 'Request Transfer' button 

 

Currently, the purchaser would have to buy all the quantity that has been added by the seller and once requested, the item would be removed from the gallery.

 

3) But we are looking for a process where the purchaser can request the required quantity. If the quantity requested is less than the quantity posted, we would like to have the leftover quantity remain on the app. 

 

Request Item Screen.png

 

 

Also, we would like to collect the data for each transfer request of that item on SP list 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-siky-msft
Microsoft

Re: Item Quantity Added & Quantity Requested Fields

Hi @Sai007 ,

 

Can you share more about the data source?

How many data sources in you apps? Do they have relationship between them?

Or do these fields belong to one data source?

 

To show leftover quantity , you can refer to the following steps:

1.  Unlock the DataCard

2.  Modify the Update property of item Quantity Added DataCard by the expression “ item Quantity Added – Quantity Requested”.

Value(DataCardValue1.Text)-Value(DataCardValue2.Text)

3.  Set Onselect property of ‘Request Transfer’ button

SubmitForm(Form1)

When the request transfer is submitted, the main gallery will show the leftover quantity.

 

If you want to collect transfer request records to SP list, you can refer to these steps:

1.  Create a SP list(transferdetail), with columns of Title, Item Quantity Added, Quantity Requested, and etc.

2.  Append the patch function to OnSelect property of ‘Request Transfer’ button to patch the request record as below.

Patch(transferdetail, Defaults(transferdetail),{Title:label1.text, Item Quantity Added: Datecardvalue1.text, Quantity Requested: Datecardvalue2.text, Leftover Quantity: Datecardvalue3.text})

So each transfer request would record in the SP list.

 

Best regards,

Sik

View solution in original post

2 REPLIES 2
Microsoft v-siky-msft
Microsoft

Re: Item Quantity Added & Quantity Requested Fields

Hi @Sai007 ,

 

Can you share more about the data source?

How many data sources in you apps? Do they have relationship between them?

Or do these fields belong to one data source?

 

To show leftover quantity , you can refer to the following steps:

1.  Unlock the DataCard

2.  Modify the Update property of item Quantity Added DataCard by the expression “ item Quantity Added – Quantity Requested”.

Value(DataCardValue1.Text)-Value(DataCardValue2.Text)

3.  Set Onselect property of ‘Request Transfer’ button

SubmitForm(Form1)

When the request transfer is submitted, the main gallery will show the leftover quantity.

 

If you want to collect transfer request records to SP list, you can refer to these steps:

1.  Create a SP list(transferdetail), with columns of Title, Item Quantity Added, Quantity Requested, and etc.

2.  Append the patch function to OnSelect property of ‘Request Transfer’ button to patch the request record as below.

Patch(transferdetail, Defaults(transferdetail),{Title:label1.text, Item Quantity Added: Datecardvalue1.text, Quantity Requested: Datecardvalue2.text, Leftover Quantity: Datecardvalue3.text})

So each transfer request would record in the SP list.

 

Best regards,

Sik

View solution in original post

Sai007
Level: Power Up

Re: Item Quantity Added & Quantity Requested Fields

Thank you so much! This solution worked perfectly.

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,583)