I have created an intake form for users. I connected this form to a share point list (Parent List) . I also connected 2 other lists to the form to populate dropdowns. When I submitt the form the fields that are connected to the two separate lists don't populate in the Parent List. Any suggjestions?
Solved! Go to Solution.
hi @Bman1991,
which columns do the two Dropdowns connect to? Are they choice type column?
Could you please share more details about the Items property of the two Dropdown boxes within your Edit form?
Further, could you please share a bit more about the Update property of the Data card which contains the Dropdown box in your Edit form?
I assume the field the Dropdown box related to is a Choice type column in your SP list, I have made a test on my side, please take a try with the following workaround:
I created three lists named “list1”(parent list), “list2”and “list3”.
Column2 and column3 are both choice type.
Title is single text.
Title is single text.
Set the items property of datacardvalue5 to :
list2.Title
set the update property of column2_DataCard2 to:
{ID:LookUp(list2,DataCardValue5.Selected.Title=Title,ID),Value:DataCardValue5.Selected.Title}
Set the items property of datacardvalue6 to:
list3.Title
set the update property of column3_DataCard2 to:
{ID:LookUp(list3,DataCardValue6.Selected.Title=Title,ID),Value:DataCardValue6.Selected.Title
regards,
eason
Hi @Bman1991,
Check the Update property of the card the Dropbox is in and. Make sure it references the correct value, for example Dropbox1.Selected.ID
hi @Bman1991,
which columns do the two Dropdowns connect to? Are they choice type column?
Could you please share more details about the Items property of the two Dropdown boxes within your Edit form?
Further, could you please share a bit more about the Update property of the Data card which contains the Dropdown box in your Edit form?
I assume the field the Dropdown box related to is a Choice type column in your SP list, I have made a test on my side, please take a try with the following workaround:
I created three lists named “list1”(parent list), “list2”and “list3”.
Column2 and column3 are both choice type.
Title is single text.
Title is single text.
Set the items property of datacardvalue5 to :
list2.Title
set the update property of column2_DataCard2 to:
{ID:LookUp(list2,DataCardValue5.Selected.Title=Title,ID),Value:DataCardValue5.Selected.Title}
Set the items property of datacardvalue6 to:
list3.Title
set the update property of column3_DataCard2 to:
{ID:LookUp(list3,DataCardValue6.Selected.Title=Title,ID),Value:DataCardValue6.Selected.Title
regards,
eason
User | Count |
---|---|
205 | |
94 | |
87 | |
47 | |
43 |
User | Count |
---|---|
252 | |
104 | |
103 | |
62 | |
57 |