Answered

Populate a box in Powerapps with Sharepoint list information

(0) Share

Report

Posted on by Manfred_Bob

I am trying to create a PowerApp for Stock Control.

I have a Sharepoint list with Title (type of item), Manufacturer and Model of the equipment I have in stock. I also have an entry for the number of each item in stock, which is manually updated.

I've managed to get cascading drop-down lists working for category (type of item), Manufacturer and Model. These allow me to end up with the model of the equipment I'm trying to check the stock for.

Beneath the Category, Manufacturer & Model Drop Down boxes I have in my Powerapp, I want a box confirming the stock level for that item, I want this to be presented as a number..

I've attached a screenshot of my SharePoint list, and PowerApp for understanding.

The title, Manufacturer, Product Code & Model Columns of my sharepoint list are all single lines of text, the Number of column is a number.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Manfred_Bob ,
You can try using below formula in Text/Default property of Number control -

Sum(Filter(SharePointListName, Model = ModelDropdown.Selected.Value), Number)

The above formula will give you sum of all values in "Number" column where Model number is same as the model number selected from dropdown.

Was this reply helpful? Yes No
Manfred_Bob 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NandiniBhagya20,

Thank you for your assistance.

I'm not trying to sum these numbers up, I just want to transpose the number in the column "number of" and correspond to the row it's sitting with into a box in my Power app.

So, although I have a column of numbers, they're for each item and I'm wanting the app to give me the number of each item in stock. I hope that makes sense.

Sorry if I'm not being particularly clear, I have autism and sometimes struggle to get my point across.

Any help would be greatly appreciated.

Thank you.

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Manfred_Bob ,
Do you want to display value in "Number of" column of the model that is selected from model dropdown. If yes, you can use below formulas -

LookUp(SharePointListName, Model = ModelDropdown.Selected.Value, 'Number of')

OR

LookUp(SharePointListName, Model = ModelDropdown.Selected.Value).'Number of'

Was this reply helpful? Yes No
Manfred_Bob 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NandiniBhagya20 ,

I'm sorry but I still can't seem to get this to work. I have a text input box and the Default formula is set to:

Lookup('Minor Works Stock - 11.10.22', Model = drp_Model.Selected.Value). 'Number of'

Minor Works Stock - 11.10.22 being the name of the list and drp_Model being the drop down for the model of the item, which is fed by two other dropdowns, drr_Category, which feeds drp_Manufacturer, which, with drp_Category feeds drp_Model.

There is an error message which is displayed on the attached picture.

I'm wondering if this is down to the formulas I've written for the drop-downs, please see the attached Word document showing these.

Sorry if I'm being a nuisance.

Thank you for being so helpful.

Drop down formula...

Was this reply helpful? Yes No
Manfred_Bob 8 on at

Like
a
(0)

Report
Copy link

Link copied!

I've managed to resolve this using the first formula suggested. "Sum(Filter('Minor Works Stock - 11.10.22',Model = drp_Model.Selected.Result),'Number of')"

Thank you for your help @NandiniBhagya20

Was this reply helpful? Yes No