Unanswered

SharePoint List not updating entry from Powerapps form after save, defaults to - entry not what is selected

(0) Share

Report

Posted on by ktownshend

I have a form that is built based off a SharePoint list. I added a Dropdown control to sort, distinct, filter selection based on another table.

The form works except for the new dropdown doens't populate the list with the selection but show the default "-" option.

Not sure what I've done wrong and why it's not populating the selection.

This is the screen shot of dropdown and the formula.

I need this selection to update the list Plaid Card Log List. Specifically the Plant Location Choice Field.

I did not create this original list, I'm trying however to make it so that a user once they select the facility, gets a limited list of Plant Locations to select from for that facility.

Any help is appreciated.

Thank you

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ktownshend ,

Without seeing your data, it is a bit hard why you get no values as this code is valid for the Items assuming a matching value is selected in DCV_Facility

Sort( Distinct( Filter( 'Facility Locations List’, Facility = DCV_Facility.Selected.Value ), field_l ), Value )

however the Update of the Data Card needs to be

{Value: YourComboBoxName.Selected.Value}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
ktownshend 83 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the advice, but this didn't work. However, this did, not sure why but it's working:

DataCardValue1.Selected
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@ktownshend ,

Assuming this is a Choice field you are writing to, If what you have works, then this should also

{Value: DataCardValue1.Selected.Value}