Answered

populate default value of combo box with person using another list with a room allocation

(0) Share

Report

Posted on by RiKx

Screenshot 2023-07-03 115136.png

I'm trying to get the combo box above to populate with the default allocated person for that room based on another list (room matrix) when a room is selected in the combo box above it but i get the displayed error about incompatible comparison types.

{DisplayName: LookUp('CHEMY Room matrix', Value('Room No.'=DataCardValue11).'Room/Area Responsible Person')}

any help would be greatly appreciated

TIA

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Bilakanti 1,226 on at

Like (0)

Report
Copy link

Link copied!

@RiKx Change your Items property to 'CHEMY Room matrix'

Was this reply helpful? Yes No
RiKx 61 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately that didn't solve it, it just listed the room numbers again...

Was this reply helpful? Yes No
Bilakanti 1,226 on at

Like (0)

Report
Copy link

Link copied!

@RiKx - Can you please change your DefaultSelectedItems property to this --> {DisplayName: LookUp('CHEMY Room matrix','Room No.'=DataCardValue11.Value)}

Was this reply helpful? Yes No
RiKx 61 on at

Like (0)

Report
Copy link

Link copied!

same again I'm afraid other that the error detail has changed to say text, error as incompat types

Was this reply helpful? Yes No
Verified answer

developerAJ 4,763 on at

Like (2)

Report
Copy link

Link copied!

if DataCardValue11 is dropdown
LookUp('CHEMY Room matrix','Room No.'=DataCardValue11.Selected.Value).'Room/Area Responsible Person'
if DataCardValue11 is text
LookUp('CHEMY Room matrix','Room No.'=DataCardValue11.Value).'Room/Area Responsible Person'

Was this reply helpful? Yes No
RiKx 61 on at

Like (0)

Report
Copy link

Link copied!

Hi Thanks for the reply! datacardvalue 11 is indeed a dropdown but this hasnt worked either its just showing the same selections as in 'room' dropdown selection.

Was this reply helpful? Yes No
RiKx 61 on at

Like (0)

Report
Copy link

Link copied!

got it to work by changing the items value back to Choices([@'CHEMY Room matrix'].'Room or Area RP') and changing 'Room/Area Responsible Person' to 'Room or Area RP' which is what its called in the other list.

Was this reply helpful? Yes No