Auto Populating a Field

Like (0) Share

Report

Posted on 15 Nov 2022 16:37:00 by CC-19121430-0

240

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

Categories:

General Questions

All responses (5)

Answers (1)

Verified answer

WarrenBelz 146,679 Most Valuable Professional on 17 Nov 2022 at 19:50:47

Like (1)

Report
Re: Auto Populating a Field

Hi @Appy1 ,

DefaultSelectedItems of Combo Box DataCardValue16 (you might look at some naming protocols for your controls)

{ 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
CC-19121430-0 240 on 17 Nov 2022 at 14:49:38

Like (0)

Report

Re: Auto Populating a Field

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
WarrenBelz 146,679 Most Valuable Professional on 16 Nov 2022 at 20:46:06

Like (0)

Report

Re: Auto Populating a Field

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 ?
CC-19121430-0 240 on 16 Nov 2022 at 11:22:40

Like (0)

Report

Re: Auto Populating a Field

Hi @WarrenBelz
Do you have any advice on this one?
Thanks
Chris
Drrickryp Super User 2024 Season 1 on 15 Nov 2022 at 18:32:47

Like (1)

Report

Re: Auto Populating a Field

@Appy1

I can't answer the first question but User().FullName to fill in the logged in user.