Yes — this is absolutely possible in Power Apps, and it’s actually a very clean pattern once the data is structured correctly.
The key is not to hard-code links per question in formulas, but instead let SharePoint drive everything.
✅ Recommended data structure (important)
You should use two SharePoint lists.
List 1 — Questions
| Column |
Type |
| Title |
Question text |
| Answer |
Yes/No |
| QuestionID |
Number |
Example:
| QuestionID |
Title |
| 1 |
Do you have VPN access? |
| 2 |
Do you have admin rights? |
| 3 |
Have you completed security training? |
This list is used for your form / gallery.
List 2 — QuestionLinks
| Column |
Type |
| QuestionID |
Number |
| LinkTitle |
Single line text |
| LinkURL |
Hyperlink |
| ShowWhenNo |
Yes/No |
Example:
| QuestionID |
LinkTitle |
LinkURL |
| 1 |
VPN setup guide |
https://... |
| 1 |
Request VPN access |
https://... |
| 3 |
Security training portal |
https://... |
| 3 |
Training FAQ |
https://... |
Each question can have multiple links.
✅ App logic flow
1️⃣ User answers questions
Use a gallery connected to Questions list.
Each row contains:
-
Question text
-
Yes / No radio control
Patch answers back to SharePoint.
2️⃣ On Submit button
After saving responses, build a collection of NO answers.
ClearCollect(
colNoQuestions,
Filter(
Questions,
Answer = false
)
);
3️⃣ Get links related to NO answers
ClearCollect(
colHelpfulLinks,
Filter(
QuestionLinks,
QuestionID in colNoQuestions.QuestionID
)
);
This automatically returns:
4️⃣ Display links on result screen
Create a gallery using:
Items = colHelpfulLinks
Inside gallery show:
✅ Result behavior
If user selects:
-
Question 1 → No
-
Question 3 → No
Then gallery shows:
-
All links for Question 1
-
All links for Question 3
Automatically.
No formulas to maintain.
✅ Why this approach is best
✔ Unlimited questions
✔ Unlimited links per question
✔ Fully data-driven
✔ Easy to maintain in SharePoint
✔ No hardcoding
✔ Works with delegation
✔ Easy to extend later
❌ What not to do
-
❌ Don’t use one column per link
-
❌ Don’t hard-code URLs in Power Apps
-
❌ Don’t use nested If statements
-
❌ Don’t use Switch() per question
Those approaches break immediately when requirements change.
✅ Optional enhancements
You can also:
-
group links by question
-
show question text as section header
-
track which links were clicked
-
store submission history
-
reuse same structure for other surveys
✅ Final answer
Yes — it is 100% possible.
The correct solution is:
-
Store questions in one SharePoint list
-
Store links in another list mapped by QuestionID
-
After submission, filter all questions answered NO
-
Load and display all related links dynamically
This is the same pattern used in compliance checklists, onboarding apps, and self-service portals.
