Hi!
I'm creating a record in Power Apps and saving it to SharePoint List with Patch() function
My List has Parent_ID and Child_ID. The Max(Child_ID)+1 within group will be next Child_ID for new record.
How to get the Max of Child_Id within group in Power Apps, ex:- How to get Child ID 13 within Parent group 10?
Tried the Sort and First formulas, they are returning the Max ID across all groups which is not i wanted.
| Parent ID | Child ID |
| 10 | 11 |
| 10 | 12 |
| 10 | 13 |
| 20 | 21 |
| 20 | 22 |
I appreciate you help!
Thanks