Unanswered

Filter Audits table on custom table

(0) Share

Report

Posted on by kts_dev

I set up a gallery and using the Dataverse connector, pointed to the Audits table. I want to filter the table to point to a custom table, and more specifically a record in that table.

In the long term, the idea would be that the user clicks on a record via gallery pointed at custom table and app navigates them to a second screen with details about the selected record. On that second screen, I want another gallery with the record's change history.

In this post I can see that I should be able to filter on Record ID. I do see Record ID in the unfiltered Audits gallery, but each GUID is unique. Therefore I don't know what I would filter on to only shows changes related to the selected record.

How do I filter the Audits table on the selected record?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

AhmedSalih 6,678 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hello, @kts_dev, Did you check @ChrisPiasecki >> https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Dataverse-Audit-Entity/td-p/858924

Was this reply helpful? Yes No
kts_dev 19 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the link @AhmedSalih . Can you confirm that the post I originally referenced is incorrect and that you cannot filter on Record ID?

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Copy link

Link copied!

@kts_dev, the post I shared is to show all record changes that is associated with a record GUID. I have used this to accomplish the same requirement that you have.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com