dropdown control - Items property changed and not writing to sharepoint

(0) Share

Report

Posted on by JimJim

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report

Hi @JimJim ,

Are these dropdown values Lookup or Person field ?

Was this reply helpful? Yes No
JimJim 289 on at

Like (0)

Report

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

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Hi @JimJim ,

For lookup fields I guess you need to pass values in below format.
ColumnName: { Value: Yourvalue }

Was this reply helpful? Yes No
JimJim 289 on at

Like (1)

Report

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

Was this reply helpful? Yes No