Unanswered

How do I use a gallery to show only the record that was just created by a form submission?

(0) Share

Report

Posted on by Future_Vision

634

I am trying to build a confirmation page that shows the values of the form that was submitted. Right now I have a gallery which shows all of the records in the data source. I want to limit it to the record the user just submitted. My thoughts is that this gallery needs to validate that the user of the app matches the the owner of the record and that the record is the most recent from that owner. I'm not completely sure how to go about that.

Another though is that I can filter the gallery based on a unique key value of the record. I'm using CDS and when viewing the columns there appears to be no such value. Is there a unique value for each record that is not exposed that I can leverage? If not maybe an option is to generate a unique ID for the record OnSuccess of the form?

Any ideas are greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Future_Vision

Your form has a LastSubmit property which represents the record that was last submitted.

If you are trying to display this in a Gallery (which is usually a list and not a single record), then you can use:

Table(yourForm.LastSubmit)

as the Items property for the Gallery.

I hope this is helpful for you.

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report
Copy link

Link copied!
Perfect! I also tried this with the value for a label doing something like this which also works.
URL4_FRM.LastSubmit.Brand
How would I hook up the edit button then? The formula you use for a gallery item won't work.
Set(glbFormData, ThisItem); Navigate('Tracking')
Would this work?
Set(glbFormData, URL4_FRM.LastSubmit); Navigate('Tracking')

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Future_Vision

What is the Item property of the form? In your scenario it should be glbFormData

Was this reply helpful? Yes No