Hello,
I am having a dropdown in my app on screen 1
Then on screen 2, i am using froms to use custom data cards.
The datacard is LookUp type as my column in SP list is "Choice Column"
Now what i want to do is use the selected value of dropdown from screen 1 and assign it to the LOOKUP in my forms,which is i am able to do by assigning the dropdown value as Default for data card.
There is a Update Property of Data Card which i need to Set to Update this value in SP list.
Now when i submit the form it does not use the default value of DataCard ,but it uses the Default value from SP list and inserts it in the SP column.
How can i make this happen?
Thanks in advance
Solved! Go to Solution.
Hi @abd3127,
I think you have noticed that the Choice field is lookup type.
So in order to have the data submitted correctly, we need to change the Default property of the auto-generated lookup control in the following format:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: Dropdown.Selected.Value}
Doing it in this way should have the default value submitted correctly. Make you you have the Value1 set to Value, in order for this field to display correctly.
Regards,
Michael
Can you provide the formula that is being used in the default property of the DataCard on screen2.
Hi @Jeff_Thorpe
I am using value of Dropdown from first screen as default value for lookup card on screen 2
Default=Dropdown.selected
Hi @abd3127,
I think you have noticed that the Choice field is lookup type.
So in order to have the data submitted correctly, we need to change the Default property of the auto-generated lookup control in the following format:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Value: Dropdown.Selected.Value}
Doing it in this way should have the default value submitted correctly. Make you you have the Value1 set to Value, in order for this field to display correctly.
Regards,
Michael