Examples from Brian on YouTube
Learn with the Nerds Events
• Power Apps Cheat Sheet: https://pragmaticworks.com/resources/cheat-sheets/power-apps-cheat-sheet-page/
• Free Developer License: https://powerapps.microsoft.com/en-us/developerplan/
Crib Notes
Dataverse • Go to https://make.powerapps.com • Go to Solutions and create a new solution called “University Honors Program” • Create a Publisher called LWTN. Display Name, Name and Prefix of LWTN • Create Application table (with attachments)
- Application Number (Auto Number)
- SAT Score – Whole Number
- ACT Score – Whole Number
- GPA – Decimal
- Applicant – Lookup (Contact)
- Parent Alumni – Yes/No
- Parent Graduation Year – Whole Number
- Parent Name - Text
- Application Status – Choice (Pending, Rejected, Approved) • Create Mentor table (with attachments)
- Mentor Name – Text
- Relationship – Choice (Parent, Friend, Teacher, Co-Worker, Other)
- Application – Lookup (Application) • Create the forms/views for Mentor
- Clone Mentor form to Portal Mentor Form Remove Application • Create the forms/views for Application
- Create a new tab for Mentor Info (Subgrid: Mentor)
- Create a new tab for Alumni Info (Parent Graduation Year, Parent Name
- Clone the Main form to a new form called Portal Application Form Remove Application Status Remove Applicant • Create a Model-Driven app (Modern Mode) with the Contact, Mentor and Application table Portal • Back at https://make.powerapps.com. • Open the Portal Management app, Edit the Portal you created earlier and open the Model-Driven Application you created earlier • Create a new page Applications and change the template to Page with Title. Set the role to Authenticated Users • Add a List named Application List to page and point it to Applications and Active Application view. • Create a new subpage under Applications called New Application
- Turn off Captcha • Go to Portal Management
- Basic Forms New Application Additional Settings • Check Associate Current Portal User and select Applicant for Portal User Lookup Column • Check Attach File • Attach File Storage Location: Notes • Attach File Option: Notes • Label: Upload Your Government ID • Try the app • Why is the Upload not there?
- Add Child Permission under Application to Notes
Advanced Form • Create in Portal Management
- Step 1 – Source Type : Current Portal User Check Associate Current Portal User on Insert as before Additional Functionality – Check Attach File as before
- 2 - Mentor Info Source Type: Result from a Previous Step
- Remove form from New Application and replace with: {% webform name:'Application Advanced Form'%}
- Create a Basic Form for Mentor
- Go back to Advanced Form Step 2 Go to Related Metadata Type: Subgrid Click Create and link it to the new Mentor form
- If time allows Create a new Web Form Step (tab for the alumni info) Create a new Web Form Step (Conditional) lwtn_parentalumni = true (may vary if you have a different prefix)