Auto Add

[Ramole]

Hello Everyone,

I need help on this please i am trying to archive this, i have a form and gallery repeating and i would when user enters Number Package field example 2 on form then the bottom repeating gallery to add 3 blank lines, whats the logic or formula to use please.

here is a screen shot 

Thanks 

[Ramole]

Hi @v-siky-msft 

I have put the code onvisble and its doing adding but when i try to delete number of packages to none the repaeting rows still there, is there a way when i clear the text box it clears the rows ?

Thanks 

[v-siky-msft · Accepted solution]

Hi @Ramole ,

Yes, try this. If the text box is not blank, save the value into a variable and create blank records, when the text box is cleared, remove the Last N records based on the variable.

If(IsBlank(DataCardValue60_2.Text),
Remove(NewShipCollection, LastN(NewShipCollection, VarNum)), 
Set(VarNum,DataCardValue60_2.Text);ForAll(
FirstN(ColNum,Value(VarNum)),
Collect( NewShipCollection,
{CItemSerialNumber: Text(Last(NewShipCollection).CItemSerialNumber + 1),
Clevel: "",
Ctc: "",
Cdescription: ""
})))

Hope this helps.

Sik