Auto Populating a Field

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@Appy1

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

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report

Hi @WarrenBelz
Do you have any advice on this one?
Thanks
Chris

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
CC-19121430-0 240 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
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

Was this reply helpful? Yes No