Power Platform Community Forum Thread Details

Hi ,

I have a sharepoint list PROJECTS that has Title Column that takes the Project name and a choice column "project stage" that allows multiple selection of choices such as Product Approval, Pilot , Launch, Post launch , UAT (5 stages in total), another column "Substage"

that is choice column with choices , Product Proposal Pilot Planning , Pilot analysis , Launch Readiness.

Now I have another list called PROJECTREQUEST that has title column , and lookup column "project name" (lookup from Projects List)

here is stage and substage

Product Approval -> product proposal

Field Pilot-> Pilot Planning,

-> Pilot analysis,

Launch -> Launch Readiness

As per the scenario a project for instance project A can have 5 stages , another project project B can have 3 stages ,

So in PowerApps how can I filter the dropdown if I select Project A , Stage dropdown should allow me to select few or all 5 stages and my substage dropdown should filter based on stage dropdown , For example for Project A if I select Field pilot the substage dropdown should only show Pilot planning and Pilot analysis , and if I select launch stage , substage dropdown should only show launch readiness ,

Can Anyone please help me with the above scenario so that how can i create proper sharepoint list relationship and how to acheice this in powerapps .

Categories:

Building Power Apps