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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,820)