cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 ItemAdd 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
Highlighted
Community Support
Community Support

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
Highlighted
Community Support
Community Support

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

Highlighted
Regular Visitor

Re: Item Quantity Added & Quantity Requested Fields

Thank you so much! This solution worked perfectly.

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,904)