Set next higher number

(0) Share

Report

Posted on by Flashback

145

Hello,

i need set variable to first next higher number than actual variable. For example a collection contain rows 1,2,3,7,9.

If my actual variable is 3 i need set 7.

Im trying this code but it not working.

Set(varRowNumber,First(Filter(colWeightOut,RowNumberInRun>varRowNumber)))

Thank you very much

Jakub

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Flashback ,

You will need to run this

ForAll( Sequence(CountRows(YourCollection)), Collect( colNo, If( !(Value in YourCollection.FieldName), {Number: Value} ) ) )

Then the number you want will be

First(coNo).Number

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

Was this reply helpful? Yes No
Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Flashback

This is an interesting question because at first glance, it appears that your original formula should work. On closer inspection, I think you're just missing a reference to RowNumberInRun (First/Filter will return a single record rather than the actual value you're looking for).

So if @WarrenBelz's solution doesn't work, you might want to try this:

Set(varRowNumber, First(Filter(colWeightOut,RowNumberInRun>varRowNumber)).RowNumberInRun )

Was this reply helpful? Yes No
vaubeee 533 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Flashback ! Another approach to this would be to generate an indexed array after your colWeightOut collection has been generated:
ForAll( colWeightOut, Collect( col_index, { value: Value, index: CountRows(col_index) } ) )
and then where needed set a variable for the next index:

Set(nextIndex,LookUp(col_index, value = rowNumber).index + 1)
and get the value from that index:
LookUp(col_index, index = nextIndex).value

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No