Multiple Item create using repeating section (Gallery)

(0) Share

Report

Posted on by AriYeom00

Hi Guys

I am trying to create repeating section to create multiple SP list items.

But somehow, last line kept creating & duplicating in SP list.

Could you please help me...?

Screen - SP

Screen - Repeating Section

Icon Submit Code

ForAll(
 Gallery1.AllItems,
 Patch(
 InvoiceLineDetail,
 {
 Title: [@TextInput1].Text,
 LineNo:Value([@TextInput1_1].Text),
 CostCenter:[@ComboBox2].Selected.Value,
 LineDesc:[@TextInput1_3].Text,
 LineAmount:Value([@TextInput1_4].Text),
 FTE: Value([@TextInput1_5].Text)
 }
 )
);

Icon Add line Code

Collect(
 invDtlCollection,
 {
 InvoiceNo: Text(DataCardValue3),
 LineNo: Text(CountRows(invDtlCollection)+1),
 CostCenter: ComboBox2.Selected.Value,
 LineDesc: "",
 LineAmount:"" ,
 FTE:""
 }
)

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @AriYeom00 ,

For the submit button, please try below formula instead:

ForAll( Gallery1.AllItems As AA, Patch( InvoiceLineDetail, Defaults(InvoiceLineDetail), { Title: AA.TextInput1.Text, LineNo:Value(AA.TextInput1_1.Text), CostCenter:AA.ComboBox2.Selected.Value, LineDesc:AA.TextInput1_3.Text, LineAmount:Value(AA.TextInput1_4.Text), FTE: Value(AA.TextInput1_5.Text) } ) );

Best regards,

Was this reply helpful? Yes No