Hello Everyone,
I have 2 SP lists :
- List 1 (Offers made)
- List 2 (Offers accepted)
For both of these lists i have made forms. List 1 form has to be completely filled by a person.
List 1 contains : Name, address, order number, company name (Normal single line text coloumn), product(Choice column)
LIst 2 contains : Name, address, order number, company name (Normal single line text coloumn), product(Choice column),
confimation date.
Order will be same for a complete order.
What i have done is i have made a cascading depending dropdown in List 2 forms . So when I insert name and order number then the fileds autopopulate based on the order number.
I was able to make cascade dropdown for all excapt Product which is a choice coloumn. I was not able to select them in power apps, beacuse the value table in properties did not showed me the product to select values from.
Is there other methond for choice coloumn to make it cascading ?
Please let me know how to make cascading dependent dropdown for a choice coloumn. If possible please reply as soon as possible.
I have attached some images too.
Solved! Go to Solution.
Hello @sk2912 ,
I have just picked up your post from the unanswered list and will try to help you. Firstly, my suggestion will involve a different method to what you are currently exploring. Please substitute any example names that are not yours with your own.
So I can get your requirements clear in my mind
Firstly, there is more than one way I can think of that will do this, however I will suggest what I believe is the easiest.
When you select a record to go to the next screen, add the following to the end of the code.
Set(vCat,DropDown2.Selected.Result);
Reset(AcceptCat)
In the Default value of AcceptCat
If(
!isBlank(vCat),
vCat,
Parent.Default //or whatever it is now
)
This will populate the field on the second screen with the value selected on the first screen.
And lastly when exiting the second screen - put this at the end of the code to reset the variable
Set(vCat,Blank())
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hello @sk2912 ,
I have just picked up your post from the unanswered list and will try to help you. Firstly, my suggestion will involve a different method to what you are currently exploring. Please substitute any example names that are not yours with your own.
So I can get your requirements clear in my mind
Firstly, there is more than one way I can think of that will do this, however I will suggest what I believe is the easiest.
When you select a record to go to the next screen, add the following to the end of the code.
Set(vCat,DropDown2.Selected.Result);
Reset(AcceptCat)
In the Default value of AcceptCat
If(
!isBlank(vCat),
vCat,
Parent.Default //or whatever it is now
)
This will populate the field on the second screen with the value selected on the first screen.
And lastly when exiting the second screen - put this at the end of the code to reset the variable
Set(vCat,Blank())
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
200 | |
185 | |
69 | |
42 | |
34 |
User | Count |
---|---|
346 | |
274 | |
124 | |
80 | |
64 |