When a text field, combobox, and people field walk into a bar? :) need some assistance with these fields, one will be a lookup

(0) Share

Report

Posted on by Km00

116

I have a unique situation with a form. This will be on a EDITform.

I have 1 Comboxbox field and 1 text field.

The text field named txtSODept_6, i need to configure into a combox instead (lets call the new ComboBox cbSODept_6) and have it show the ThisItem.SO_Dept_Displayname as the default. The ThisItem.SO_Dept_DisplayName is a text value.

I also need the combobox cbSODept_6 to have the following for dropdown options: DataSource: 'Department List'.Title

The 2nd field is another combobox and is a PEOPLE Field. This combobox is called: DataCardValu69_5

The DataCardValu69_5 default value should show the current ThisItem.Doc_Owner on screen load. Then when the cbSODept_6 NEW Combobox dropdown changes, the Peoplefield (a.ka. DataCardValue69_5) will show the following Lookup:

LookUp('Department List',Title=cbSODept_6.Selected.Title).Document_Owner

I can't for the life of me get this to work.

If i get the 'viewform' on screen looking working, then when i change the cbSODept_6 combobox doesnt work and vice versa.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Km00 116 on at

Like
a
(0)

Report
Copy link

Link copied!

My Biggest issue is the people field.

How can i get it to show the Default value ThisItem.Doc_Owner, then on change of the other combobox, have it update to the correct value from the Lookup
Verified answer

Km00 116 on at

Like
a
(0)

Report
Copy link

Link copied!

So i don't know if this is the final answer or not but i ended up doing a few workaround.

Basically adding under the people field datacard, a hidden Combobox4, and put in If statement on the DefaultSelectedItems. If(vEditPencil=true,DataCardValue69_5.Selected,ThisItem.Doc_Owner) then set the cards update value to the hidden combobox.

Did the same for the SODept field. the cbSODept_6 combobox is visible, the txtSODept_6 and the text for that is: If(vEditPencil=true,cbSODept_6.Selected.Title,ThisItem.SO_Dept_DisplayName)

I honestly don't know how else to do it, and i feel like their might be a easier way out there however ive spent way too much time on this for now.

I'll do more testing tomorrow to make sure it in fact, works. 🙂