Solved: Create Ticket Number based on Data on SharePoint

Hi there.. I'm a total newbie when it comes to using Power Apps. I attempt to develop a ticketing system using SharePoint and Power Apps. After that, Power Automate generates the ticket number. However, the issue is that the Ticket Number has just started to appear on my Power Apps UI when I enter new data from my Power Apps form. What happens if you want it to show up alongside objects in Power Apps at the same time?

review formpopup if the ticket sucessfully submittedcode in submit buttonmy sharepointmy power automate

Categories:

General Questions

Mobile App

You should be able to capture the values generated in SharePoint within a context variable and then output the ticket value in the success screen you are showing in your app, without the need to use a Power Automate Flow.

If the field is auto-generating, you can use the LastSubmit() property of the Form to capture that autogenerated value. This post (Solved: Quick question - LastSubmit() - Power Platform Community (microsoft.com)) from a while ago, talks about it some.

Basically, in the OnSuccess property of the form control, you can use the following:

UpdateContext({varTicketNumber: Self.LastSubmit.'Nomor Tiket'})

Then use the varTicketNumber value to display in the Ticket Number field here:

If you need the flow to run in order to generate the ticket number, then you can store the ID of the record in your context variable, then use a LookUp() function on your list to lookup the ticket number field from SharePoint using the ID value to attempt to capture the value dynamically.

Let me know if that helps!