Power Platform Community Forum Thread Details

Hi Everyone,

I'm not a programmer, a newbie to Power Apps and desperately need help. I've been trying to resolve this on my own for a couple of weeks now and now so frustrated. I created an app with a form and in the form, I have an Edit Request, New Request and New Allocation buttons.

Can you please help with the formula on the following? I attached 2 screen prints to hopefully help.

Scenario 1: When the user clicks on the Edit Request button, I need Power Apps to dynamically populate the Allocation ID field with last max id + 1, if blank.

Scenario 2: When the user clicks on the Edit Request button then clicks on the New Allocation button, I need Power Apps to dynamically populate the Allocation ID field with last max id + 1 while keeping the same Request ID.

The New Request is working but I've also attached a screen print with formula. Both Request ID and Allocation ID generates as desired (max id + 1).

I hope this is not too complicated and thank you so much in advance! Any help will truly be appreciated.

Thanks,

Mary