Unanswered

One asset containing more assets

(0) Share

Report

Posted on by SH-23070720-0

Hello,

A bit of a complicated one here!

I have an asset management Microsoft List with an integrated Power App (auto-created using the integrate option on Lists).

We're planning to put an asset tag on each room that we have in the building. I want to be able to scan the asset of the room and the app show the assets that are in that room. I've got the app to use a barcode scanner to search for an asset tag but I don't know how to get it to present the assets in the room.

I haven't seen anything on Lists or Apps that says you can have a record in a record, but it would work perfectly for us if I had a room and inside the room was a number of assets.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Adrian_Celis 1,652 Moderator on at

Like (1)

Report

Hi @HeronS98
In PowerApps you can have a record within a record if you use a collection.
For your case, you can have one table for Rooms then another for Assets with a reference column ID.
So in your PowerApps, if one selects a room, you can show all the assets that are inside the room.

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report

Hi @Adrian_Celis,
So how would you go about doing this?
I understand that I would have to create a new List with all of our rooms and a unique identifier and put the same identifier on my asset manager. Where can I find collections in Power Apps?

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like (1)

Report
Hi @HeronS98
You're correct. Take note that the column named 'ID' in any list is already automatically generated so you can use that as your unique identifier.

Let's say this is your two tables:

The 'RoomsID' column in the Assets list is related to the 'ID' column in the Rooms list.

You don't have to use collections in PowerApps if it is as simple as this.
In your PowerApps, you can filter assets based on any room you have selected by filtering the IDs.
If you use a gallery, then in the Items property you can use something like:

Filter(Assets, RoomsID = 1)

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report
I created a new Microsoft List called Ref and put a room in there with a number.
When I put your formula in, I am changing it from

SortByColumns(Filter([@'Asset Manager'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

to
Filter(Assets, RoomsID = 1)
and it throws up errors.

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like (1)

Report
Well, If you only made one table then the problem you are trying to solve would not work.
But for this one table as an example, you need to change the formula according to your List name.
If your list name is Ref then it should go something like this:
Filter(Ref, *Put Your Column Name Here* = *Put Value Here*)
Make sure you have connected that list in your data sources.

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report
Alright,
I have added the Ref as a data source.
For testing purposes, I added a room to the Ref table, ID number 1.
I then did a lookup column in my normal asset table for the ID number in the Ref and connected it to an asset.
When I type in
Filter(Ref, RoomID = 1)
I don't receive any errors now, but nothing appears when I type in 1.

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like (1)

Report

@HeronS98
That formula will work if your column type is a plain Number column and not a Lookup column. It would help if I can see both of your lists and all of its columns so I can show you the proper formula.

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report

So I have one Microsoft List. It is named Ref and currently has one record in it as below:
I have a different Microsoft List that contains my assets. I have added RoomID as a number field to this as per below:

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report

Essentially what I want is to be able to scan a barcode that relates to a room name and then the app show what assets are in that room.
I hope it makes sense, I'll make up a scenario using random assets and barcodes.
So I have a room, lets call it AA01. The barcode for it is AABBCC01.
I have three assets, TT22,TT23,TT24 that are all in the same room, AA01.
When I scan the room barcode AABBCC01, I receive TT22,TT23, and TT24 as they are all in that room.

Hope this makes sense, sorry for putting you through this! I'm not so clued up on PowerApps as you can tell.
Thanks for all your help.

Was this reply helpful? Yes No
Adrian_Celis 1,652 Moderator on at

Like (0)

Report
@HeronS98
Thank you for giving me info on your tables.
Ok so far you are on the right track. First you need to know how galleries and filtering works. Then you are one step closer to solving your problem.
Since you need to show items from your Assets table, then use this formula in the Items property of a gallery:

Filter(YourAssetsTableNameHere, RoomID = 1)

Make sure your gallery has a layout so you can see the items.

Let me know if something appears in your gallery.

Was this reply helpful? Yes No