Dynamics Community Forum Thread Details

Power App - Item Journal - Create Multiple Lines

I created a Power App to show users all available item then let them to select multiple and items then increase or decrease the QTY in Power App. Then post them into Item Journal

But I run to the issue that I get an error for Line No. I tried both below methods but looks like each time Power App try to create one line then create the new line without increase line no.

Is it anyway that I can fix my Power App code to create multiple line a the same time (like upload from Excel)?

I try to avoid adding Line No to my app since it get complex.

Method one: to loop through each line. Still shows error that line no exist.

ForAll(
    ItemJournalPositiveEnryCollection,
    If(
        !IsBlank(ItemNo_),
        Patch(
            'item_Journal_Lines (hougaard/SOD/v2.0)',
            Defaults('item_Journal_Lines (hougaard/SOD/v2.0)'),
            ThisRecord
        )
    )
)

Method two: send them all at the same time but I get the same error

Patch('item_Journal_Lines (hougaard/SOD/v2.0)',ItemJournalPositiveEnryCollection)

Quick Links