Answered

Combo box pick not saving

(0) Share

Report

Posted on by Ironbird207

I have a form that has a combo box where you would select a lot number which is filtered by a text box with a UPC number in it. I can get it to populate correctly but when I pick a lot number and save, it reverts back to being blank and nothing updates in the sharepoint list the form is tied to.

My filter for the combo box

Filter(
 lot_1,
 UPC = DataCardValue7.Text
 )

lot_1 is a spreadsheet with lot numbers and UPC codes.

The update function on the datacard this resides in is

DataCardValue9.SelectedItems

However it has an error saying expected text value.

Hoping to get some help with this issue.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Sort by

zuurg 546 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Is the SharePoint list's field that DataCardValue9 supposed to write to set for multiple choices, or just single selection?

Was this reply helpful? Yes No
Ironbird207 16 on at

Like (0)

Report
Copy link

Link copied!

The sharepoint list is a text field and the combo box is set to only allow a single selection.

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The reason it is expecting a text value is because that's what your SP List's type is. If you're trying to pull in a single selection from the Combobox to write to a field type of text, try switching your Update for that DataCard to be DataCardValue9.Selected.Value

Was this reply helpful? Yes No
Ironbird207 16 on at

Like (0)

Report
Copy link

Link copied!

I changed the update to DataCardValue9.Selected.Value and now it claims the Name isn't Valid. 'Value' isnt recognized.

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

After you press the . after "Selected", what fields does the intelltype thing tell you are available? Yours might not be called Value.

So: type DataCardValue9.Selected then hit the . and wait to see what is available.

Was this reply helpful? Yes No
Ironbird207 16 on at

Like (0)

Report
Copy link

Link copied!

It populates my excel spreadsheet columns which are Lot No and UPC, Lot no's are what I want so I entered
DataCardValue9.Selected.'Lot No'
The error went away but still doesn't enter any data when saving the form, goes blank again and nothing writes to sharepoint.

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

What is the DataCardValue9's Items property set to?

What do you have the form's DataSource set to?

Was this reply helpful? Yes No
Ironbird207 16 on at

Like (0)

Report
Copy link

Link copied!
DatacardValue9 is the following code, lot_1 is a spreadsheet
Filter( lot_1, UPC = DataCardValue7.Text )
The form's data source is set to "Customer Service Log" which is a sharepoint list.

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hmmmm. What happens if you try to change the update property for the combobox's data card to statis text like "Test"?

Was this reply helpful? Yes No
Ironbird207 16 on at

Like (0)

Report
Copy link

Link copied!

Same result, sharepoint field doesn't update.

Was this reply helpful? Yes No