You’re offline. This is a read only version of the page.
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.
Fair enough,
I will mark your last post as a solution as it does technically work for what is required.
Thanks again.
We've been going on a lot of topics for this one thread and perhaps this will not end soon. Apologies I cannot help further. Maybe you can ask a question for a more specific problem that you have in PowerApps in another post.
In my case, assets have letters in them, so I would have to make the type 'single line of text' for both.
So how would I go about creating a collection for them?
I'd have the asset tag for all the individual assets, and the room ids that i want to search.
Yes that would be possible. I would suggest that the columns in both lists that you are searching for are the same column types (e.g. Number). You would filter both lists, then put them in a collection.
Yes, that shows room ids perfectly, thank you for that.
So I see the individual assets in the layout and can search room ids and it find different rooms.
Is there a way it can search for both individual assets and the room ids or is it only one?
Thanks for all your help so far!
Okay that's where we take it a step further. Since you now made the items appear in the gallery, you can make the RoomID value dynamic.
If you have a textbox named Textbox1, you can have the Items property of your gallery as:
Share
Report
All responses (
Answers (
Filter(YourAssetsTableNameHere, RoomID = Value(Textbox1.Text))
So now you can type in any value in the textbox, like 1 or 2.
So I put the formula into the Items property, and it does bring up all rooms associated with RoomID 1.
But then I can't search for assets that aren't in RoomID1. So I can't search for items in RoomID 2 for example because the search box is only looking for RoomID 1.
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.
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.
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:
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
