no submit data on combobox AGAIN!

[KinYan]

Yes, recently I posted a message(combox-box-no-submit-data ) which ask why no submit data for one of the combobox, thanks for @v-bofeng-msft who fixed the issue perfectly.

today, similar issue happen again, can someone help me fix it , thank you.

There are 2 List:

List A: Departments

Office: Choice

Department: Single line of text. the column name changed from title to Department.

TeamLead: Person or Group

FolderPath: Single line of text

List B: Roles

Role: Single line of text

Office: Choice

Department: Choice

---------------------------------------

Roles PowerApps:

combo box name:
Office: cbOffice_C

Department: cbDepartment_C

Items property:

Office combo box: Choices([@Departments].Office)

Department combo box: Filter(Departments, Office.Value = cbOffice_C.Selected.Value)

---------------------------------------

try @v-bofeng-msft 's solution, but fail

LookUp(Choices('Roles'.Department),Value=cbDepartment_C.Selected.Department)

have no idea, why so difficult to submit data for a combobox....

[v-bofeng-msft]

Hi @KinYan :

Could you tell me:

• Does Department(Roles) allow multiple selections?
• Which table are you updating?Roles or Departments?
• Does your code have value(LookUp(Choices('Roles'.Department),Value=cbDepartment_C.Selected.Department))?I suggest that you can first check whether the following code has obtained the target value

Best Regards,

Bof

[KinYan]

My reply as below in RED:

• Does Department(Roles) allow multiple selections? No
• Which table are you updating?Roles or Departments? I'm updating Roles
• Does your code have value(LookUp(Choices('Roles'.Department),Value=cbDepartment_C.Selected.Department))?I suggest that you can first check whether the following code has obtained the target value Please see below capture

[v-bofeng-msft · Accepted solution]

Hi @KinYan :

Your settings seem to be fine,I just suspect that this code does not get the value.

Please add a lable control,and set it's text property to:

LookUp(Choices('Roles'.Department),Value=cbDepartment_C.Selected.Department).Value

Then check if this label control shows any value.

Best Regards,

Bof

[KinYan]

hi @v-bofeng-msft , i know what's the reason, sorry, my bad.