I'm trying to report on PowerApps table which filled and updated manually, I need to find all rows which were not updated for 10 days. Currently this information is not part of user defined column.
However I've learned how to find metadata like on the pic below, you need to open table, double click on given row, then Related, then Audit History.
How I can access this data, whatever I tried didn't work, do you think in general it's possible ? I could not find this anywhere in PowerApps manuals.
Or I need to add custom column with current update time for each of my tables? [![enter image description here][1]][1] [![enter image description here][2]][2]
Well the table with logical name 'audit' can give you a log of all the change information of 'Audit enabled' fields. You can use XRMToolBox (FetchXML Builder or SQL for CDS to see the structure of data).
If any fields are not audit enabled, they would not appear here. You can enable/disable field audits on attribute edit screen.
The issue now is that each record in 'audit' table has a JSON which should field, old value and new value. if you just generally intend to find the record not updated in last 10 days, then it is fine. But it would be tricky and problematic to find out if a specific field (or a set of fields) hasn't been updated in last 10 days. If that is the case, you can create date fields and have workflows setup to change date to current datetime everytime your chosen fields get updated.