Hi,
I have created a collection which contains 2 to 3 text fields and the rest are look up in my SP list.
Example:
Name: Jacky //text field
Age: 28 //text field
Company: ABC.com //look field
so, first thing i want to ask, can i use a created collection as my data source (on edit form) save it to my SP list?
If yes, then how to map look up fields with collection data? because after creating collection i am trying to map look up field to my collection value and it says "Expected a record value".
2nd thing i want to ask, when creating a collection it saves values as simple text even if its a look up value. For example:
ClearCollect(mySPList, {Name: DataCardValue10.Text, Age: DataCardValue12.Text, Company: DataCardValue15.Selected.Value})
so when i am patching my values back yo SP list, again it says "Expected a record value" on Company field.
Simply what i want is, Use created collection in my edit form or do it other way like not using form and patch it y SP list
Thanks.