how to build a Form with few section and increment upload of one section. need help.. thanks

(0) Share

Report

Posted on by bbsin

1,994

I have a complex form and not sure how to create in PowerApp, can anyone help?

Need to create one nomination form with the 3 sections as one FORM

Section one - fill in personal info by Nominator A

Section two - fill in list of 9 nominatees - name , department and two more info - how to have increment fill in and view at the same at the same time without re-entering Section one again.

- one question on declaration to click click Yes/ No

- enable to upload pdf supporting file

Section three - 3 supporting info with declaration to click

how to view the 9 nominatees info and the pdf file in the browser view screen

Step 2, when all the information are submitted, how can the approver view the 9 nominatees details in the view screen and have with in the screen create comments box to input ??

lastly, all data & attachments to update into SharePoint list

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @bbsin

Could you explain a bit about the relationships between Nominators and Nominees? Can a Nominator also be a Nominee? Can a Nominator nominate multiple nominees?

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

hi,

yes, so a nominator can input up to 9 Nomiess's name and some info related.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can a nominator be a nominee and can a nominee have more than one nominator?

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

no

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @bbsin

You have a one-to-many relationship between nomenators and nomenees. The best practices for your app is to have two lists, one of Nomenators and one for nomenees. The nomenee list should have a number field for nomenatorID in addition to the other attributes of the nomenee such as department, attachments, etc. Later, you will link the two lists by referencing the ID of the Nominator from a gallery or a dropdown control with the Items property of the Nominator list. (to avoid problems later, do not use a SharePoint lookup field to reference the other list). Once you have the two lists created let PowerApps built the basic app using your Nomenees list as the datasource from make.powerapps.com. Then bring the Nomenator list into the app.

Please reference my blog posts on how to build the app based on a one to many relationship. https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640 and an illustration of how to do it in the subsequent post using an example of Customers and Orders which in your case would be Nominators and Nomenees.
https://powerusers.microsoft.com/t5/News-Announcements/Relational-Database-Design-fundamentals-Implementing-a-One-to/ba-p/200521 .

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

thanks

will check it out. 🙂

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

Nominator - only the executives level like the Dept heads - they cannot be nominated
Nominator can be anyone (all staff) and only one nominee
but another person also can nominee the nominator expect the Dept Heads

If Nominee had received the award with two years, they cannot be nominated till 3yr

Was this reply helpful? Yes No