web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Using a Lookup to Incr...

Power Apps

Answered

Using a Lookup to Increment a value not working

(0) Share

Report

Report

Posted on by dgarrick

24

I have a model driven app with a embedded canvas app.

The canvas app has one gallery showing existing records in a table called (AFP Payment Schedules) based on a Job Number.

The second gallery I'm using with a collection to enable the user to input information and then I patch that into the AFP Payment Schedules table.

What I'm having a problem with is I'm trying to get last ID number (AFP Number) from the AFP Payment Schedules table, based on the Job Number and then increment ID by one. The second gallery should then be automatically listing the new line of info to be entered with the next AFP number after what already exists. The code I'm trying is below, but what I get returned each time is a zero.

The existing AFP number is 1 so I'm expecting my new line in gallery two to be a 2 as its incremented 1 by 1.

Set(LastTotalAFP_ScheduleLines, LookUp('AFP Payment Schedules', 'Job Number' = [@ModelDrivenFormIntegration].Item.'Job Number').'AFP Number');

Set(TotalAFP_ScheduleLines, LastTotalAFP_ScheduleLines +1);

The collection then incorporates

AFPNumber: TotalAFP_ScheduleLines,

Thanks in advance for any help on this

David

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @dgarrick ,

Please try this:

Set( LastTotalAFP_ScheduleLines, First( Sort( Filter( 'AFP Payment Schedules', 'Job Number' = [@ModelDrivenFormIntegration].Item.'Job Number' ), 'AFP Number', SortOrder.Descending ) ).'AFP Number' ); Set(TotalAFP_ScheduleLines, LastTotalAFP_ScheduleLines +1);

Best regards,

Was this reply helpful? Yes No
dgarrick 24 on at

Like (0)

Report
Copy link

Link copied!

That worked perfectly, thank you.

Was this reply helpful? Yes No

Join the conversation