Autopopulate fill in the blanks gallery items based on quantity entered in a field

[Yaswini24]

Hi there,

I am hoping if someone could assist me i want to be able to populate blank fields depending on the user input for quantity but I am not sure how to do so , if anyone could assist me as to how I can link the field with the gallery it would be much appreciated. 

For example, if user keys in 4 in the Lot/Batch Qty, I would want the gallery to display 4 rows of blanks for user to input their data.

I know is tough I have been watching a lot of tutorials on it but the problem is everyone is using existing data in my case is only new input no existing data for it , so everytime user keys in it will create a new row in my sharepoint list

Thank you , 

Wini

[Ethan_R]

Hi @Yaswini24 ,

You can try the following:

[Suggested to keep a button to create rows else OnChange + delay properties can help you as well]

ForAll(
    Sequence(Value(<TextInputQty.Text>)),
    Patch(
        <Datasource>,
        Defaults(<Datasource>),
        {
            //any required fields if needed
        }
    )
)

This will show several blank rows for Gallery.

[Note: If you are treating gallery as sub-grid then make sure you mentioned for which record these blank rows are, else you will be creating blank rows without any relation to existing record]

Hope this helps

[WarrenBelz]

Hi @Yaswini24 ,
EDIT - I see @Ethan_R has provided the same solution.

Try

ForAll(
   Sequence(Value(YourTextInput.Text)),
   Patch(
      DataSource,
      Defaults(DataSource)
   )
)

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.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Yaswini24]

For the for all part do i insert it into the gallery item, if let's say i were to do a flow would it be more easier?

[Yaswini24]

I got an error , mainly is for the patch

[Yaswini24]

Abit of an update:

Currently I can add the blank rows but i can only add one at a time because the input from the field I am using does not seem to sync

Add Button Code

Gallery Code

I shall upload a vid here i hope that is clear enough to see

[Yaswini24 · Accepted solution]

Final Update I managed to solve it 

This is my solution I would like to thank @WarrenBelz  and @Ethan_R for helping me.

Button Item > OnSelect Property

Gallery > Items Property (In my case my gallery is in a data card cause it is in a form 🙂

Row No Text Label

IconRemove > OnSelect Property