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 / dropdown control - Ite...
Power Apps
Unanswered

dropdown control - Items property changed and not writing to sharepoint

(0) ShareShare
ReportReport
Posted on by 289

Hi Guys,

As the header suggests, I have an edit form connected to a SP list (List 1), I've updated the Item property on a couple of dropdown lists (dd_1 and dd_2) to read from another SP list (List 2), it reads the data ok from List 2 but isn't writing back to List 1, when I submit the form it writes to all other fields except the two controls that read from List 2.

Obviously, dd_1 and dd_2 are custom cards as I had to edit them, in order to get around the issue I added the default cards for dd_1 and dd_2 and attempted to reference the values from the custom cards but my formulas aren't working. I have tried dd1.SelectedItems and dd1.SelectedItems.Result, both return error 'The property on this control expects record values. The rule produces Table values which are incompatible'

Categories:
I have the same question (0)
  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    Hi @JimJim ,

     

    Are these dropdown values Lookup or Person field ? 

     

  • JimJim Profile Picture
    289 on at

    Hi @PriyankaGeethik ,

    They are lookup fields. The Item property is something like Sort(Distinct(sp_List2,Title),Result)

    And the update property of the card is dd_1.SelectedText

  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    Hi @JimJim ,

     

    For lookup fields I guess you need to pass values in below format. 

    ColumnName: 
    {
    Value: Yourvalue
    }
  • JimJim Profile Picture
    289 on at

    Thanks for taking the time to reply, I got it working in the end simply by deleting the data card and adding it again. This time instead of changing the control from edit text to allowed values, I deleted the control completely and added a dropdown control. I have no idea what the difference is

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 325 Most Valuable Professional

#2
11manish Profile Picture

11manish 165

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 88 Super User 2026 Season 1

Last 30 days Overall leaderboard