Answered

Display multiple value on data card or gallery base on a selection

(0) Share

Report

Posted on by caslasgee

223

Is it possible to display a multiple related values in a gallery or a form. For example, I have 2 tables in a sharepoint list, List A and B as attached. I am able to display an item base on a dropdown.

I used

LookUp('List A',PrID=ThisItem.ID, Title)

and this displays only DO.123 on a data card. I would like it to display Both DO.123 and DO.211 either on a data card or a gallery since there is a relationship between both list.

Thanks.

Categories:

Building Power Apps

DB_structure.png

I have the same question (0)

All responses (15)

Answers (1)

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @caslasgee ,

Try Filter instead of LookUp

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
caslasgee 223 on at

Like (0)

Report
Thanks @WarrenBelz . Do you mean i should replace the lookup function with filter function? Thus

LookUp('List A',PrID=ThisItem.ID, Title)

???

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
@caslasgee ,

Just replace it

Filter( 'List A', PrID=ThisItem.ID ).Title

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
caslasgee 223 on at

Like (0)

Report

Hi Warrenbiz, the code needs to be closed. I can see there is 1 open parentheses and 2 closed parentheses.

Thanks.

Was this reply helpful? Yes No
caslasgee 223 on at

Like (0)

Report

HI, Any support please?

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

@caslasgee ,

Just a typo - fixed

Was this reply helpful? Yes No
caslasgee 223 on at

Like (0)

Report

Thanks, I tried and i still receive same error. Just would like to display it in a gallery. If i put the above code in the list item of the gallery, it tells me Name isn't valid. Thisitem isn't recognized.

Thanks

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

@caslasgee ,

Can you please explain in a bit more detail exactly what you are trying to do here ?

Was this reply helpful? Yes No
caslasgee 223 on at

Like (0)

Report

Ok. Like earlier stated, below is my sharepoint list (2 List)

I already have an entry page to collect the above information. As seen from the above, there is a relationship between both tables (List A is PrID and List B is ID). What i want is to be able to modify an entry that contains all the field. If i am to use the edit or view form option, It only displays the below.

I would like it to show all its field that is associated to Mr Armal i,e showing both DO.123 and DO.211 with its individual amounts considering the list relationship (PrID and ID).

Or is there another way this can be done?

Was this reply helpful? Yes No
NurSabrina24 165 on at

Like (0)

Report

Try to Filter without the Title column

Was this reply helpful? Yes No