Increment gallery records

(0) Share

Report

Posted on by geraldc1820

The code below works fine and increments rows from a collection connected to a gallery. I want to have it increment up until a title row and then reset to 1 on the first row after the title. The title data will be blank on the rows it needs to increment:

Please modify:

ClearCollect(
    editTable,
    ForAll(
        Sequence(CountRows(editTable)),
        Patch(
            Last(FirstN(editTable, Value)),
            {RowNumber: Value}
        )
    )
);  

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

ronaldwalcott 3,847 Moderator on at

Like (0)

Report
Copy link

Link copied!

Create a new variable incrementValue set it to 1 before the ClearCollect

You are still incrementing using Value but setting the increment to the record based on the new incrementValue variable

You reset the incrementValue based on your condition back to 1. Not sure what you meant by after so you may have to move where you do the reset and reset to 0 instead then increment.

The syntax is a bit off I am not typing on my desktop and I don't know exactly the condition you are checking for.

Something like this should work

UpdateContext({incrementValue: 1});

ClearCollect(

editTable,

ForAll(

Sequence(CountRows(editTable)),

If(titlerowvaluecheck,UpdateContext({incrementValue: 1}));

Patch(

Last(FirstN(editTable, Value)),

{RowNumber: incrementValue}

);

UpdateContext({incrementValue: incrementValue + 1});

)

);

Was this reply helpful? Yes No
geraldc1820 37 on at

Like (0)

Report
Copy link

Link copied!

Thank you. That concept makes sense but PowerApps will not allow variables set inside a ForALL.

Was this reply helpful? Yes No
ronaldwalcott 3,847 Moderator on at

Like (0)

Report
Copy link

Link copied!

Didn't realise that.

Instead of using a variable we can try using a table with patch.

Set(incrementTable, Table({valueIncrement:1}));

Patch(incrementTable, First(incrementTable), { valueIncrement:First(incrementTable).valueIncrement + 1 })

Replace as appropriate and see if it works. I am assuming that Patch does not execute concurrently and ForAll waits for the completion.

Was this reply helpful? Yes No