You’re offline. This is a read only version of the page.
Hello everyone,
Hope you are doing well!
Could someone possibly advise me how I can auto-populate a field within a form based on a criteria.
For example here, I would like 'system' to be populated with a choice if Employee id is completed with something beginning with 4 i want system to be auto populated, the same if Employee ID is populated with something beginning with E i want system to be populated with something else.
I also have another question, it is if my form field of 'Logging Person' could be completed by the app recognising who has logged on to complete the form? and if so how to do this.
Thank you very much!
Chris
Hi @Appy1 ,
DefaultSelectedItems of Combo Box DataCardValue16 (you might look at some naming protocols for your controls)
Share
Report
All responses (
Answers ({
Value:
If(
StartsWith(
DataCardValue1,
"4"
),
"System1,
StartsWith(
DataCardValue1,
"E"
),
"System2,
. . . . .
)
}
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hi @WarrenBelz,
Thanks for your reply and apologies, I will try my best to explain exactly.
I want to be able to populate a DataCardValue within a form (Form1).
If EmployeeID is completed with a number beginning with 4, i know that employee ID sits within a certain system for example 'System1', if it begins with the letter E, i know that it belongs to another system 'System2'.
I was hoping to pre-populate this to speed up the completion for whoever uses my form.
Items within my DataCardValue are currently just the selections of system written as ["","System1","System2", "Both"].
Many thanks for taking a look.
Chris
Hi @Appy1 ,
Can you please provide more detail on the first question - what do you want populated in System and how are you then specifying what it is ? Also what are the Items of the Combo Box, its name and the name and type of field you are writing back to ?
#1
WarrenBelz
89
Most Valuable Professional
#2
MS.Ragavendar
60
#3
stampcoin
48
