Unanswered

Check availability of Inventory Items in Sharepoint list from Powerapps

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@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.

Was this reply helpful? Yes No
k-chops 14 on at

Like (0)

Report

@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 !

Was this reply helpful? Yes No