
Announcements
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