How to add and save dynamic text boxes for each new customer record

[BradAugustene]

I am facing challenge in creating and saving "dynamically" text field data for customer record.

I am building application screen. It has customer detail and each customer record has one or multiple nominee names.
On customer record screen, user can decide to add or remove  and increase or decrease the total number of Nominee field.

User can click UP or DOWN arrow icons to increase or decrease total number of nominees.

New nominee text boxes must be created once user click OK button.

Example: user decides for 4 nominees for specific customer, then 4 text box fields should be created.

Once user enter nominee names and click SAVE button, I want same number of nominee details should be saved in the Dataverse.

Example: If user selected 5 nominee and enter 5 nominee names for Customer Record A, then 5 names should be saved in dataverse.  Next time if user select 7 nominees for another customer Record B then 7 nominees text fields should be available for user to enter 7 nominees names and then save the 7 nominee names in the database.

I need help or ideas for:

a) How to create new text input fields dynamically for user decided number for nominees.

b) How to save the nominee names every time when user click the save button and link saved nominee names with each customer record.

I am confused for how to link and save variable number of nominee names for each customer record.

Any ideas / suggestion or code snippets may be helpful.

Sharing screenshots of my application screen for more insights.

Thanks in advance.

[developerAJ]

if there is no limit on nominees than it is better to Store them in a single column seperated by seperator (;)

You can use gallery 

items: Sequence(urnumbertextinput.text)

add a textbox in gallery. where user enter nominee.

or just use editable gallery (2) Power Apps Editable Grid using Gallery & Modern Controls (2023) - YouTube

Concat(Gallery.allitems,galleryTextinput.Text,";")

it will concat all items: Ex: A;B;C

[BradAugustene]

Hi AJ

Thanks a ton for sharing creative solution to my problem.

I tried your suggested option 1 and it works. However I am unsure of saving it in database with each nominee name as separate column in Dataverse. I am able to save all nominee names separated by ; (semicolon) symbol in single column however I am unable to pull the specific nominee name from dataverse column.

Is it possible to separate each nominee name from single column (example 5 nominee names) which has all nominee names separated by ; and save it in each rows (5 rows) or in each current (5 columns) dataverse table or may be another table?

It is difficult to guess how many nominees will be added to each customer by user upfront so I am unable to decide how many new columns I need to create for each nominee names upfront. So I believe saving each nominee name in new row and linking each nominee name to customer record unique ID will be good solution. 

My scenario:

After saving the all nominee names in dataverse (and linking to them to customer record ID) , I wish to pull specific nominee name and fill nominee full name, address, phone number and email address in database.

Example: User entered 4 nominee names.

Using your suggestion, I saved 4 nominee names in single column with semicolon separator.

Now I wish to pull each nominee name from single column and separate each nominee name ending with semicolon.

For each nominee name I wish to fill full name, address, phone number, etc and save this detail in database. 

I created separate column for full name, address and phone number and email in dataverse.

I am unable to pull each nominee name individually from NOMINEE single column (each name separated by semicolon symbol) and fill full name, address, phone number, email detail for each nominee and save it in 4 columns in dataverse linked to each nominee names.

Any suggestion/ideas please....