Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Unanswered

Dataverse choice columns and Modern Dropdown issue

Posted on 3 Dec 2024 12:05:33 by 88
I have a Dataverse table with a Choices column to select an Appraisal Type in a Canvas App.
 
Pulling the choices through to the dropdown items works:
 
              Items = Choices('Appraisals'.'Appraisal Type')
 
I am using the following in the DefaultSelectedItems of the DropDown, but as shown below it doesn't recognise the field:
  
 
I have the value of the selected gallery item shown in the Text component below
 
 
that is what should be the selected item in the dropdown:
 
 
 
 
 
 
Thanks in advance.
Steve
  • Suggested answer
    Pacel1 Profile Picture
    Pacel1 35 on 04 Dec 2024 at 09:49:46
    Dataverse choice columns and Modern Dropdown issue
    put it in square brackets and it should work :)

  • StevenMoore Profile Picture
    StevenMoore 88 on 04 Dec 2024 at 08:41:42
    Dataverse choice columns and Modern Dropdown issue
    Pacel1 - that's the problem, modern DropDown does not have a plain old Default:
     
  • Pacel1 Profile Picture
    Pacel1 35 on 03 Dec 2024 at 14:13:00
    Dataverse choice columns and Modern Dropdown issue
     So I believe that You have to use simple method in Default property :)

    just place there the same what You have in Text component

    galAppraisals.Selected.'Appraisal Type'



     
  • StevenMoore Profile Picture
    StevenMoore 88 on 03 Dec 2024 at 13:39:13
    Dataverse choice columns and Modern Dropdown issue
    Pacel1 - thanks for response.
    This is more generic and simpler than it sounds, all I'm trying to do is display the current choice in a dropdown and giving the user the choice to change. I have used a collection as the datasource but this is the same as using the underlying table as a source, and the result is the same.
     
    "Appraisal Type" Choice column in Appraisal(s) table:
     
    Collection: colAppraisal is just the whole Appraisal(s) table:
    ClearCollect(colAppraisals,Appraisals);
     
    Gallery : galAppraisals items:
    Filter(colAppraisals,'Staff Member'.Mail = selectedUser.mail)
     
    The current Choice should be selected and the other choices available to choose from, this works except the current choice.
     
     
     
  • Pacel1 Profile Picture
    Pacel1 35 on 03 Dec 2024 at 13:02:48
    Dataverse choice columns and Modern Dropdown issue
    It's hard to understand what You actualy would like to do, without data :)

    Please share details about:

    -Your gallery datasource
    -Dataverse Table structure
    -What is inside colAppraisals

     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,372

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,900

Leaderboard