Hi there, I would appreciate help in a project.
I need to move this form https://forms.monday.com/forms/d314aff55bfa83dce73e4b09e80421fb?r=use1 and functionality from Monday.com to the Microsoft 365 environment. It's too complex to use Microsoft Forms, so, I'm using PowerApps to build it.
I’m building a Power Apps form connected to a SharePoint list. The form is used for event support requests, where users select what equipment or support they need (e.g., Marquee, Bins, BBQ Trailer, Portaloo, etc.).
The goal is to make the form interactive — when the user (Citizen from public) selects one or more items in the Equipment / Support Requested (multi-select choice) field, only the relevant question sections appear. Here is a live working form: https://forms.monday.com/forms/d314aff55bfa83dce73e4b09e80421fb?r=use1
For example:
If they select Marquee, the form shows Marquee-specific questions (size, quantity, delivery, etc.).
If they select Bins, the Bin-related questions appear.
If they select BBQ Trailer + Bins, an extra note appears about BBQ cleanup and waste disposal.
If they select all, all question groups appear, each within its own container.
At the end, there’s a Conditions of Use question (single choice with “Agree”) that must be selected before submission.
I want to achieve:
Conditional visibility logic for containers (sections) based on multi-select choices.
Validation so users can’t submit unless required fields in visible sections are complete.
“Agree” must be selected before submitting.
Auto-count how many equipment types were selected (saved in SupportCount column).
Optionally, compile a combined “Conditions of Use” text based on selected equipment items.
I’ve already:
- Connected the app to the SharePoint list.
- I've had multiple attempts at creating the app, however, it's not working. I've done a few tutorials on Microsoft Learning and am hitting blocks using AI to help.
Core fields: EventName, Organisation, Venue, ContactName, Phone, RequesterEmail, EventStart, EventEnd, HireOutDate, ReturnDate, EventDetail, Attachment
Dynamic trigger field: EquipmentSupportRequested (Choice – multi-select). SupportCount (Number).
Equipment sections (conditional):
Marquee: Size, Quantity, Anchoring, Delivery, Pickup, Notes.
Bins: Quantity, Location, Notes.
BBQ Trailer: Quantity, Notes.
Portaloo: Quantity, Location, Notes.
Visual Message Board: Quantity, Message, Notes.
Cinema Package: Location, Date, Notes.
6-Piece Stage: Location, Setup Date, Notes.
Out-of-hours Toilet Access: Location, Times, Notes.
Fee Waivers: Type, Details.
Conditions & workflow fields: ConditionsAgree (“Agree” only), ConditionsUse (compiled text), Status, Workflow, ApproverNotes, ApprovingOfficer, PermitAmount, ApplicantAmount.
Thank you for your help in advance.