You’re offline. This is a read only version of the page.
I'm trying to figure out a way for my PowerApp that has two Galleries. I need to have the Audit Gallery that uses the Main Gallery selected Item using a SQL Table (dbo.AuditTest) information. In the Audit Gallery I need to show ALL items that have been changed/updated from the Main Gallery on submits. For example: You select a row (Main Gallery) that opens up a form to make updated changes then feeds into SQL Table called dbo.AuditTest. On the FORM there is a icon1 that will open up the Audit Gallery. Here is where I need to show ALL changes for that particular MainGallery selected Item.
I'm new to PowerApps, and my apologies just not sure how to display this information in my Audit Gallery. Any help/suggestions will be appreciated. Thank you!
For example: In the SQL Table (dbo.AuditTest) I have the following items: I need to show ALL changes like below: So, on my Main Gallery I did select row ID 1.
| ID | Name | AssignedTo | Sender | Address | Comments | UpdatedByUser | UpdatedDateTime |
| 1 | Jane Doe | Mickey Mouse | John Doe | 111 Doe Lane | testing | Test\username | 9/16/2022 20:12 |
| 1 | Jane Doe | Donald Duck | John Doe | 111 Doe Lane | testing | Test\username | 9/17/2022 21:12 |
| 1 | Jane Doe | Donald Duck | John Doe | 111 Doe Lane | testing test 11 | Test\username | 9/20/2022 18:12 |
@RandyHayes - Thank you! Got it. Added in a filter and it worked. Thank you again.
@Anonymous
You would need to filter your Audit table by information pertaining to that main gallery selection (preferably by the ID of the record).
I am not seeing any record Identification in your list...so you might want to consider putting the record ID in your audit list and then it would be quite simple with just a Filter statement.
I hope this is helpful for you.
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (