Unanswered

Display Form Record based on value from a Gallery

(0) Share

Report

Posted on by Community Power Pla...

Howdy,

I'm working on an inventory PowerApp and I'd like to have a screen that has three items - a gallery of users (UserGallery), a display form with the record from the selected user (UserInfo), and another display from that shows the details of the device that's assigned to the user (StationInfo). The information for this is on two Sharepoint lists - one for Users and another for Assets. The User list has a lookup column that picks the Asset by the title name.

I've tried a lookup, but I get an error with the equal size not being valid. Is this even possible or do have the lists built incorrectly for this to work? Thanks in advance for the help.

Categories:

Building Power Apps

MSFTPA.jpg

I have the same question (0)

All responses (11)

Answers (0)

kidvallejo 100 on at

Like (0)

Report

Can you show me the vlookup you have tried?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

So based on the following working,
LookUp(Assets, Title = "Station 94")

I tried
LookUp(Assets, Title = UserGallery.Selected.Computer) &
LookUp(Assets, Title = DataCardValue9) &
LookUp(Assets, Title = DataCardValue9.Text)
(Where DataCardValue9 is the DataCard showing the station name that would match the title in assets)

Those didn't work and I'm guessing it's because I don't have that formatted correctly.

Was this reply helpful? Yes No
kidvallejo 100 on at

Like (0)

Report

Ok, how many assets do you have I sharepoint to lookup? If it's over 500 that could be your issue, try using:

Search(Assets,datacard9.text,title) or

First(Filter(assets,title=datacard9.text),title)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

There are 148 assets. I tried both of those formulas and they did not display any results.
To be sure, that formula needs to be entered into the Item field of the Display Form correct?

Was this reply helpful? Yes No
kidvallejo 100 on at

Like (0)

Report

Sorry, I think I misread something earlier...Do they select the asset or does it look up from the user field?

If the asset form is looking up from the user form (asset form should be an edit form mode) and the item should be set to:
First(Filter(Assets, Title = datacard9.text))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The asset form should lookup from the user form. In all, I'd select the user from the user gallery, the userinfo form (display mode) would show the users' info and then the stationinfo form (in edit mode?) would display the station's info based on matching the title of the asset to the computer name field in the userinfo form (datacard9)

I added an Asset form in edit mode and tried the formula, but still didn't get any results.

MSFTPA1.jpg

Was this reply helpful? Yes No
kidvallejo 100 on at

Like (0)

Report

Ok the issue is the datacard part... should be datacardvalue9

Also, temporarily add a button and put the following: Newform(UserFormName); NewForm(AssetFormName)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Updated First(Filter(Assets, Title = DataCard9.text)) to First(Filter(Assets, Title = DataCardValue9.text)) and still nothing.
For the heck of it, I also tried to make the User Form in Edit mode to see if that would work, but I'm still getting an "Invalid Argument Type" error.

By the way, thanks for your help with this, I appreciate it greatly.

Was this reply helpful? Yes No
kidvallejo 100 on at

Like (0)

Report

take out the .text if it comes up with a mismatch then it could need text(datacardvalue9)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Tried both to no avail, still showing as invalid. As a test, I added a text input and set the list for the Asset form
First(Filter(Assets, Title = TextInput1))) and that worked. The station field in the User Form is a dropdown selector, not just a text input, could this be why First(Filter(Assets, Title = Text(DataCardValue9))) not working?

Was this reply helpful? Yes No