Share via

Help Building Interactive Power Apps Form with Conditional Sections (Based on Equipment Selection)

Daniel 6 Reputation points
2025-11-11T05:02:18.5333333+00:00

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.

Fields in My Form

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.

Microsoft 365 and Office | SharePoint | For business | Windows
{count} vote

1 answer

Sort by: Most helpful
  1. Viego An 8,990 Reputation points Microsoft External Staff Moderator
    2025-11-11T07:56:48.0033333+00:00

    Dear @Daniel,

    Thank you for reaching out to Microsoft Q&A forum. We are happy to assist.

    To ensure you receive the most accurate and effective guidance, I recommend posting your question on the Microsoft Power Platform Community Forum. This forum is dedicated to Power Apps, Power Automate, and related technologies, and it brings together product experts and experienced users who specialize in these scenarios. They can provide detailed examples, best practices, and tailored solutions for your needs.

    When posting your question, please include:

    • A clear description of your goal and the issue you’re facing.
    • Screenshots or sample formulas if possible.
    • Any error messages or unexpected behavior you’ve encountered.

    This will help the experts respond quickly and accurately.

    We truly appreciate your understanding and cooperation. If you need assistance with other Microsoft 365 services or have general questions, feel free to reach out to us anytime, we’re here to help.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.