Wednesday, May 17, 2023

Converting a collection to JSON & Vice versa

 

 JSON(col_AllHistory, JSONFormat.IndentFour )

ClearCollect(col_AllHistory, ForAll( Table( ParseJSON( yourItemStoringJSON ) ), { ChangedBy: Text(ThisRecord.Value.ChangedBy), Comments: Text(ThisRecord.Value.Comments), DateOfChange: DateTimeValue(ThisRecord.Value.DateOfChange), Status : Text(ThisRecord.Value.Status) } ))

No comments:

Post a Comment

Add Service Principle support in Custom Connector

  then search for "Streamlining Integration: Using Service Principal authentication on Custom connectors with Microsoft Graph Applicati...