You’re offline. This is a read only version of the page.
35
We are offloading a bunch of our Audit History from 365 to local SQL Server tables. But we want this audit history, along with audit history that still exists in 365 to be visible from CRM via a power app.
So .. simple enough i can add the Audit History table into Power Apps from 365 .. Change Data is a JSON column in there.
Now I'd like to get the 3rd column, which is the change data .. into another datatable inside each Item.
I'm trying to do this for the Items collection in that subgrid, just one column for now:
ForAll(
Table(ParseJSON(ThisItem.'Change Data')),
{
changedAttributes: ForAll(
Table(Value.changedAttributes),
{
type:Text(Value.logicalName)
}
)
}
)
error i'm getting is the following:
Any ideas?
Share
Report
All responses (
Answers (
