web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Get Max ID within Grou...

Power Apps

Answered

Get Max ID within Group from SharePoint List to PowerApps

(0) Share

Report

Report

Posted on by Sitara

5

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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
You can use the Max() function. Try this:

Max(YourFilteredData,ChildID)
For example:
Max(Filter(YourSharePointList,ParentID=1),ChildID)
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Sitara
Try this:
Max(Filter(your_datasource_name, ‘Parent ID’=10), ‘Child ID’)

—-
Please Accept As Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

Was this reply helpful? Yes No
Sitara 5 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much

Was this reply helpful? Yes No

Join the conversation