web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / populate default value...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 61

Screenshot 2023-07-03 115136.png

 

Hi

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

Screenshot 2023-07-03 115136.png
Categories:
I have the same question (0)
  • Bilakanti Profile Picture
    1,226 on at

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

  • RiKx Profile Picture
    61 on at

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

  • Bilakanti Profile Picture
    1,226 on at

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

  • RiKx Profile Picture
    61 on at

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

    RiKx_0-1688384466337.png

     

     

     

  • Verified answer
    developerAJ Profile Picture
    4,763 on at

    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'

     

     

     

     

  • RiKx Profile Picture
    61 on at

    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. 

  • RiKx Profile Picture
    61 on at

    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. 

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard