I'm sure this is possible, but not enitrely sure how it is achieved.
I want to lookup the current users User().FullName when an app is opened and then auto populate a dropdown field with this value that can be edited is needed?
Thanks for the help in advance!
Go to Solution.
This could be achieved. For example, I have a Excel table named Table1 with 2 columns: Created By and TicketID. I have Default property of Created By column as: User().FullName.
Insert a dropdown control, and set its Items property to
Filter(Table1, Created_x0020_By = User().FullName)
Set its Value property to TicketID, then the dropdown pick list would be shown with the TicketID columns that has created by current user.
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.