Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Dropdown field selected value is not the same value displayed in list item record

(0) ShareShare
ReportReport
Posted on by 85

I built a canvas app that uses a dropdown field connected to a secondary lookup list. I can successfully select any of the values from the source list, however, after I submit the form it returns "50" for some reason. It's the weirdest thing. I have a flow that updates, however, it's not touching that field at all.

 

Not sure where to go from here.

  • Verified answer
    ShawnPelletier Profile Picture
    ShawnPelletier 85 on at
    Re: Dropdown field selected value is not the same value displayed in list item record

    Fixed it! Added another "Choice" column in list settings with all the choices and used the lookup function to the secondary data source to get the state I was looking for, then proceeded to remove the column causing the issue.

     

    Used the below formula in the text field (default) for grabbing the corresponding column data I needed.

     

    LookUp('Company Site Numbers', Title = DataCardValue1.Selected.Value).State

  • ShawnPelletier Profile Picture
    ShawnPelletier 85 on at
    Re: Dropdown field selected value is not the same value displayed in list item record

    How do I map to the SharePoint list column that I need? I'm a little perplexed as I've never had this issue with other apps I've built in PA using the same setup (or so I thought?)

     

    The funny thing is, I've matched this field up with the exact same setup I have in the edit PA form (which works)!

  • Ethan_009 Profile Picture
    Ethan_009 4,836 on at
    Re: Dropdown field selected value is not the same value displayed in list item record

    Hi @ShawnPelletier ,

     

    I doubt if your field 'Company Sit Number' is mapped to the field of your datasource.

    Please check the mapping once again of your existing text field. 

    Since if you change any control (for ex: text to dropdown) then you have to map the dropdown's value on text field so it will save the correct data.

     

    Else it is just a independent dropdown value reading data but not putting on your form while you submit. 

     

  • ShawnPelletier Profile Picture
    ShawnPelletier 85 on at
    Re: Dropdown field selected value is not the same value displayed in list item record

    I just recreated another canvas form. This time it's not submitting the value I choose to the record (field value is blank). The field (Company Site Number) is a standard text field under list settings. In the form I changed it from text to "Allowed Values" which changed it to a dropdown.

    Under properties [Items] for the text input I have "Company Site Numbers" which is the secondary data source. Under properties [Value] for the text input I have "Title" which is the correct column. When I preview or publish the form the correct value show up in the field and when I select a valid choice.

     

    Now when I submit the form the column in the list view returns blank\empty. My submit formula is below.

     

    OnSelect= submitForm(P2P)

    OnSuccess = NewForm(P2P);Notify("P2P submitted successfully...",NotificationType.Success);Navigate(P2P,ScreenTransition.Fade) 

     

    Everything works correctly except the blank value for the company Site Number field.

     

     

     

  • Bilakanti Profile Picture
    Bilakanti 1,226 on at
    Re: Dropdown field selected value is not the same value displayed in list item record

    @ShawnPelletier where is the value "50" coming from?

  • Ethan_009 Profile Picture
    Ethan_009 4,836 on at
    Re: Dropdown field selected value is not the same value displayed in list item record

    Hi @ShawnPelletier ,

     

    I'm not sure what "50" is but if its count of records then check Row Limit in PowerApps settings as that's delegation limit.

    Can you show any visuals indication to know what you are trying to achieve?

    Also, how are you filtering the values of dropdown? 

    Also check which records is the flow updating and is necessary value passed to the flow.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard