cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sai007
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
v-siky-msft
Community Support
Community Support

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
v-siky-msft
Community Support
Community Support

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

Thank you so much! This solution worked perfectly.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,703)