Skip to main content
Community site session details

Community site session details

Session Id : 1OpPXQ7g7u6AwvTPpuUnkp
Power Apps - Microsoft Dataverse
Unanswered

Dataverse app dropdown selections

Like (0) ShareShare
ReportReport
Posted on 9 Oct 2023 22:29:54 by 6

Hello, I'm developing an application that utilizes Dataverse tables. Within my application, I have two dropdown lists whose data is sourced from another Dataverse table. Each column in these dropdown lists has properties of type Text. My objective is for when the user presses a button, the selections made in each dropdown list are saved in the corresponding columns of my main Dataverse table, which is named 'project.' Currently, I'm working with the following formula:

 

Project;
Defaults(Project);
{
Store: store_.Selected.Value,
Route: route_.Selected.Value
}

 

  • Michael E. Gernaey Profile Picture
    45,250 Super User 2025 Season 2 on 10 Oct 2023 at 04:36:29
    Re: Dataverse app dropdown selections

    @Night_wi 

     

    A few things

     

    1. Can you show me the error itself, show me what CODE is actually red. I do not see a RED on the code I gave you in the photo. So please find the code that is underlined in Red and show me that on the Button

    2. What is the name of each dropdown box?

    3. What are the names of the Columns?

    4. Are these Dropdowns or ComboBoxes

    5. Please show me the Items properties of the dropdowns

    6. I cannot see the last ) in the code I gave you if you can just make sure its there

     

    I assure you, that in a dropdown DropdownControlName.SelectedText is how you get the text. So there is something you aren't telling me or showing me.

     

    Please show me the actual fields in the Dataverse Table, I'd like to see the configuration.

     


    If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Night_wi Profile Picture
    6 on 10 Oct 2023 at 02:20:30
    Re: Dataverse app dropdown selections

    I want that, when selecting a value from the dropdown list, the selections are saved in each of the columns using 'patch'. However, I still have issues with the arguments. Both the table from the dropdown list's source column and the 'project' are of text type.

     

    "The type of this cr5cd_store argument does not match the expected type "Text". Found type "Record""  

    Night_wi_0-1696904193494.png

     

  • Michael E. Gernaey Profile Picture
    45,250 Super User 2025 Season 2 on 09 Oct 2023 at 22:35:22
    Re: Dataverse app dropdown selections

    Hi, @Night_wi 

     

    The patch statement would be this, if that is the question, or issue, sorry can you specify?

     

    Patch(Project, Defaults(Project),
    {
    Store: store_.SelectedText,
    Route: route_.SelectedText
    }
    )

     


    If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete