Creating an interactive FAQ/Contact finder

%3CLINGO-SUB%20id%3D%22lingo-sub-1335847%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20an%20interactive%20FAQ%2FContact%20finder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1335847%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635241%22%20target%3D%22_blank%22%3E%40S_I_N%3C%2FA%3E%26nbsp%3Byou%20can%20do%20this%20with%20Power%20Apps%20connected%20to%20your%20lists.%20Let%20me%20know%20if%20you%20need%20the%20detailed%20steps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22cascadingGallery.gif%22%20style%3D%22width%3A%20548px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F186501i68026A150684E3AE%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22cascadingGallery.gif%22%20alt%3D%22cascadingGallery.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337897%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20an%20interactive%20FAQ%2FContact%20finder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337897%22%20slang%3D%22en-US%22%3EThanks%2C%20but%20alas%20(unless%20I%20messed%20up%20with%20the%20version%20of%20sharepoint)%20there%20is%20no%20powerapps%20or%20flows.%20Which%20sucks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1334639%22%20slang%3D%22en-US%22%3ECreating%20an%20interactive%20FAQ%2FContact%20finder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1334639%22%20slang%3D%22en-US%22%3E%3CP%3EA%20complicated%20one%20this%2C%20so%20I%20shall%20try%20to%20explain%20best%20I%20can.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20end%20result%20of%20all%20this%20is%20a%20page%20where%20the%20user%20picks%20an%20activity%20from%20a%20drop%20down%20(or%20however%20best%20to%20display%20the%20options).%20It%20then%20shows%20another%20list%20of%20all%20courses%20within%20that%20activity.%20Finally%20when%20they%20pick%20the%20one%20they%20want%2C%20it%20will%20show%20details%20of%20the%20person%20running%20that%20course.%20However%20to%20complicate%20matters%2C%20the%20same%20person%20could%20be%20a%20trainer%20on%20multiple%20courses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20made%20some%20lists%20to%20prepare%2C%20one%20for%20the%20trainers%2C%20one%20for%20all%20the%20courses%20and%20one%20for%20the%20list%20of%20activities.%20But%20perhaps%20I%20am%20going%20about%20this%20wrong.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20best%20way%20to%20achieve%20what%20I%20am%20after%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assumed%20I%20could%20use%20lookup%20columns%20but%20my%20mind%20has%20just%20gone%20blank%20on%20where%20to%20start%20or%20even%20if%20what%20I%20want%20it%20possible.%20I%20even%20thought%20of%20using%20Infopath%20in%20some%20capacity.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1334639%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

A complicated one this, so I shall try to explain best I can.

 

The end result of all this is a page where the user picks an activity from a drop down (or however best to display the options). It then shows another list of all courses within that activity. Finally when they pick the one they want, it will show details of the person running that course. However to complicate matters, the same person could be a trainer on multiple courses.

 

I have made some lists to prepare, one for the trainers, one for all the courses and one for the list of activities. But perhaps I am going about this wrong.

 

What is the best way to achieve what I am after?

 

I assumed I could use lookup columns but my mind has just gone blank on where to start or even if what I want it possible. I even thought of using Infopath in some capacity.

2 Replies
Highlighted

@S_I_N you can do this with Power Apps connected to your lists. Let me know if you need the detailed steps.

 

cascadingGallery.gif

 

Rob
Los Gallardos
Microsoft Power Automate Super User

Highlighted
Thanks, but alas (unless I messed up with the version of sharepoint) there is no powerapps or flows. Which sucks