web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Formula Help: Finding ...

Power Apps

Answered

Formula Help: Finding previous record and incrementing the number

(0) Share

Report

Report

Posted on by phillippoole

85

I have a requirement for an app need help finding the easiest solution

I need to lookup a Master Data Table and pull the last/most recent record where 2 conditions lie:

Column1 (text): Previous record isnt blank but were an alphanumeric number will populate

Column2 (choice): Yes

Once these conditions are clear, I need to get that most recent record from Column1 and increment it one and post into the next record.

AND

If that record Column1 is blank to Patch or Set Variable to 10000 (which would be the starting number).

Does that make sense?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @phillippoole ,

Please try:

With( {LastColumn1:First(Sort(Filter(ListA,Column2.Value="Yes"),Created,SortOrder.Ascending)).Column1}, If( LastColumn1="", 10000, Value(LastColumn1)+1 ) )

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation