Hi All ,
Hope you're doing good.
I create an app that loads people into a collection.... this is ok...
I patched a multiline field in a SharePoint list with the JSON value of my collection
Patch(
testPeople, //Name of my SPList
Defaults(testPeople),
{
Title:"Test JSON",
TablePeople:JSON(colPeople) //Name of my collection
}
)
So i end up with my TablePeople field (mulitline) containing my collection.
[{"@odata.Type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|Victor@xxx.net","Department":"","DisplayName":"Victor","Email":"Victor@xxx.net","JobTitle":null,"Picture":""}]
Now i'm trying to push this table back into an other collection in my app...
Set(varTest,LookUp(testPeople,Title="Test JSON",TablePeople));
ClearCollect(colTablePeople,
ForAll(
Table(ParseJSON(varTest)),
{
odata:Text(Value.odata),
Claims:"i:0#.f|membership|" & Text(Value.Email),
Department:"",
DisplayName:Text(Value.DisplayName),
Email:Text(Value.Email),
JobTitle:Text(Value.JobTitle),
Picture:""
}
)
);
and this...is not working 😅
...and i see i get an error saying : JSON paring error : unexpectd token '<' , "<div class"... is not a valid JSON
when i look at the value returned in my variable i see this ....
<div class="ExternalClass7E438A091C7746C18005EB5CE3BC96B8">[{"@odata.Type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|victor@xxx.net","Department":"","DisplayName":"victor","Email":"victor@xxx.net","JobTitle":null,"Picture":""}]</div>
and i'm a bit lost ....
Could someone be able to help me with this please ?
Thanks a lot !
