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
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.
Also, we would like to collect the data for each transfer request of that item on SP list
Solved! Go to Solution.
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
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.
User | Count |
---|---|
262 | |
110 | |
98 | |
54 | |
39 |