Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 0DwTj3u8PCSdUHqMHr3C6/
Power Apps - Building Power Apps
Unanswered

Create New Form by Product and Create New Form by Product Group

Like (0) ShareShare
ReportReport
Posted on 15 Jun 2023 17:58:55 by 13

I need help trying to figure out how to adjust the buttons connected to my forms. Attached is an example dataset. Please help!

 

The purpose of this form is to provide users a way to save information (Comments, Price, Units, Date) at the product level (Gala Apple, Fuji Apple, Grapes). I would like to create two buttons, "New Record - Product" and "New Record - Group".

 

"New Record - Product" - when selected, will create NewForm(Form1) with a record ID that is the highest Recid + 1 for the product. For example, since the highest Recid for Gala Apple is 5, the new form will prepopulate Recid with 6. How do I accomplish this?

 

"New Record - Group" - when selected, will create NewForm(Form1) with a record ID that is the highest Recid + 1 for the product group. For example, since the highest Recid for Gala Apple is 5 and Fuji Apple is 2, the new form will prepopulate Recid with 6 (using Gala Apple, since it is the highest). How do I accomplish this?

 

I have set global variables SelectedProduct (specified product) and SelectedRecord (specified record number), as well as a collection ProductRecords (all record numbers for specific product). However, I am not able to make any formula that seems to work. Would there be a difference if I used a Set or Collect/ClearCollect formula?

 

Any help will be greatly appreciated!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 294 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 169

#3
stampcoin Profile Picture

stampcoin 130

Overall leaderboard
Loading started