Unanswered

Check availability of Inventory Items in Sharepoint list from Powerapps

Like (0) Share

Report

Posted on 7 Feb 2022 21:45:43 by k-chops

Relatively new to powerapps and flow and am struggling with a specific use case that I am hoping someone here can assist with.

I have a sharepoint list that is used as a master inventory list for rental equipment. it is set up with an availability column that displays Available, reserved, in use, etc

I am building a power app to be able to reserve/request equipment and I want the user to be able to tell if the equipment is available before requesting it. to accomplish this I am hoping to have a button within the form datacard for the "itemtype" (column that separates the equipment into smaller categories) so that which ever they have selected for example 'skis' or 'ski poles' for them to be able to click the button and that button check the list and return the number of 'Available" items from the list. snip of my list for reference.

2021-11-02 20_46_31-Qui Gon Jenn - Discord.png

any and all assistance is greatly appreciated!!!!

Categories:

General Questions

All responses (2)

Answers (0)

k-chops 14 on 08 Feb 2022 at 14:40:45

Like (0)

Report

Re: Check availability of Inventory Items in Sharepoint list from Powerapps

@RandyHayes Thank you for this info, I will try it tomorrow and get back to you if this is the solution I am looking for !
RandyHayes 76,287 Super User 2024 Season 1 on 07 Feb 2022 at 21:50:11

Like (0)

Report
Re: Check availability of Inventory Items in Sharepoint list from Powerapps

@k-chops

This can be accomplished with the GroupBy function.

Ex.

GroupBy(Filter(yourList, Available.Value="Available"), "ItemType", "_items")

This can be used as the Items property for a Dropdown where the user can select the Item type.

A second dropdown, combobox, Gallery, listbox, etc can be used to display the available items. For that the Items property would be: yourFirstDropdown.Selected._items

I hope this is helpful for you.