Announcements
Hi I would like to create an application to check tickets but I don't know what formula to use for the text form where the ticket number will be entered and for the button that will check this number. The ticket number database is created in Google Sheets😀
From my understanding of what you're looking for, you will want to perform a LookUp on your data source (in this case, Google Sheets).
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup
So your formula would be something like this:
LookUp(GoogleSheetTickets, TicketID = input.Text)
Where TicketID is the column from Google Sheets and input.Text refers to your text input where the user will type the ticket number.
Hi
I’ve created a similar Help Desk application in Power Apps, which explains everything step-by-step — from ticket creation to status tracking and admin management.
You can check out my full video tutorial here: https://youtu.be/CmDcavOxFec?si=LM5eHE4Y2o5-MvqI
This video will help you build your own Help Desk app easily and also answer most of the common questions that come up during development.
Hope it helps! 😊 — Pankaj Jangid (Oyepanky)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
