Answered

Data not saving to SharePoint table from Combo box

(0) Share

Report

Posted on by cage4000

Good Afternoon everyone,

I've ran into an error that i can relay use some help on. I have a Combo box (ComboBox1) that lists the Title of a SharePoint List (tblAssociateTeam) where all the titles are. The Editform that this combo box resides on is connected to another SharePoint list (tblSafety). I want the value of the combobox to be recorded on the tblSafety.Leader_Nm field on the SharePoint. Everything i have tried has not worked when setting the Update on the datacard to the combobox field. I have tried setting the datacards Update field to ComboBox.Text / ComboBox1.Selected / ComboBox1.Selected.value but all 3 do not work. i will list some print screens to help better illustrate my issue. any help is much appreciated.

Here is what i have that feeds the combobox:

ComboBox1 Items = SortByColumns(Filter(tblAssociateTeam,Department="ASSISTANT MGRS"),"Title")

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Verified answer

WarrenBelz 154,393 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @cage4000 ,
Try ComboBox1.Selected.Title

If this post helps, then please consider Accept it as the solution to help the other members find it more. It also closes the item.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@cage4000

What is the data type of 'Leader_Nm' field?
If Leader_Nm field is a Text, please try this:

ComboBox1.Selected.Title

If not, please share more details.
Sik

Was this reply helpful? Yes No
cage4000 16 on at

Like (0)

Report
Copy link

Link copied!

I'm sorry but that did not work.

Yes, it is a text field from the SharePoint list. I will attach screen shots of the SharePoint list to help. Also, attached are screen shots of the DataCard Advanced propertys and the ComboBox Advanced propertys.

Was this reply helpful? Yes No
cage4000 16 on at

Like (0)

Report
Copy link

Link copied!

Add on to previous post.

Was this reply helpful? Yes No
cage4000 16 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@cage4000
The first letter of 'Title' should be capitalized, could you please try again?
Sik

Was this reply helpful? Yes No
WarrenBelz 154,393 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @cage4000 ,
If the solution you need is as my first post (and thank you @v-siky-msft for the help), you might consider accepting mine as the solution.

Was this reply helpful? Yes No
cage4000 16 on at

Like (0)

Report
Copy link

Link copied!

A capital did the trick, thank you. Now it is giving me the "An entry is required or has an invalid Value error" when i try to submit the form. do you know why it is saying this when i try to submit the record? Please see attached.

Was this reply helpful? Yes No
cage4000 16 on at

Like (0)

Report
Copy link

Link copied!

I had to delete out the Leader_Nm and replace it with a new column and that did the trick.. its ready to go. Thank you all for your help with this.

Was this reply helpful? Yes No