cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vignesh_2112
Helper II
Helper II

Custom forms, Sharepoint list, dropdown box

Hi all,

I have a SharePoint list that has different categories and corresponding action items. The Powerapps user must be able to pick options for each and every category and once submitted, the corresponding action items need to be shown for the user. Please refer to the attached screenshot of my need. 

 

The Categories should possess a dropdown list from Sharepoint and once submitted, the action items to be shown in a Text box.

 

Thanks in Advance!!!

2 ACCEPTED SOLUTIONS

Accepted Solutions
yashag2255
Dual Super User II
Dual Super User II

Hi @Vignesh_2112 

 

You can set the "Text" property of the label to:
 
LookUp(DataSourceName, 'Category A'=Dropdown1.Selected.Value && 'Category B'=Dropdown2.Selected.Value && 'Category C'=Dropdown3.Selected.Value ).'Action Items'
 
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

@Vignesh_2112 

 

You can either do 

 

LookUp(DataSourceName, 'Category A'=Dropdown1.Selected.Value && 'Category B'=Dropdown2.Selected.Value && 'Category C'=Dropdown3.Selected.Value ).'Action Items'

 

Or if you want to show action items even when only one dropdown or two dropdowns are selected as well as the case for all three dropdowns, you can also try:

 

LookUp(DataSourceName, If(IsEmpty(Dropdown1.Selected.Value,true,'Category A'=Dropdown1.Selected.Value) && If(IsEmpty(Dropdown2.Selected.Value,true,'Category B'=Dropdown2.Selected.Value) && If(IsEmpty(Dropdown3.Selected.Value,true,'Category C'=Dropdown3.Selected.Value) )

 

 

 

View solution in original post

10 REPLIES 10
v-monli-msft
Community Support
Community Support

Hi @Vignesh_2112 ,

 

Could you please try to explain what you want to achieve step-by-step in PowerApps with the sample data?

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I don't have sample data, lemme explain as you requested,

I have a list of items in a table form, and I have populated the table with all possible combinations. This table will act as a source file for my app.

 

Category ACategory BCategory CAction Items
abX1
aaaX2
bbbX3
X4
aabX5
abbX6

 

As shown in the above source table, the Power Apps to be created where, Categories A, B & C need to be Dropdownbox for the user to select. Then once all the three categories are selected, the App should display the corresponding action items for the combination.

 

Thanks!!

 

yashag2255
Dual Super User II
Dual Super User II

Hi @Vignesh_2112 

 

You can set the "Text" property of the label to:
 
LookUp(DataSourceName, 'Category A'=Dropdown1.Selected.Value && 'Category B'=Dropdown2.Selected.Value && 'Category C'=Dropdown3.Selected.Value ).'Action Items'
 
Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

@Vignesh_2112 

 

You can either do 

 

LookUp(DataSourceName, 'Category A'=Dropdown1.Selected.Value && 'Category B'=Dropdown2.Selected.Value && 'Category C'=Dropdown3.Selected.Value ).'Action Items'

 

Or if you want to show action items even when only one dropdown or two dropdowns are selected as well as the case for all three dropdowns, you can also try:

 

LookUp(DataSourceName, If(IsEmpty(Dropdown1.Selected.Value,true,'Category A'=Dropdown1.Selected.Value) && If(IsEmpty(Dropdown2.Selected.Value,true,'Category B'=Dropdown2.Selected.Value) && If(IsEmpty(Dropdown3.Selected.Value,true,'Category C'=Dropdown3.Selected.Value) )

 

 

 

View solution in original post

Hey @Vignesh_2112 

 

A dropdown selection cannot be empty so the first expression that i have provided would suffice in this case.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

@Vignesh_2112 

 

As long as all three dropdowns are always having to be set, and as long as there is not a case when a combination of three values can overlap with more than one value @yashag2255 solution will work.

 

Note that LookUp returns only the first record. If you want more than one, and if you want to return those, you may need to use another function that returns a table, also possibly use a variable, then use something like ForAll to iterate through and concatenate to that variable, to for example say items X1, X2, and X3 need to be returned. The solution with LookUp will only work if you are absolutely sure, you only want the one action item corresponding with the columns, rather than multiple columns.

@Vignesh_2112 

 

Based on the data shared by you, this has an item where all the columns could be equal so based on different combination of the three columns, there is a value defined and the expression will pick it.
 
Dropdown by default selects its first item and will be changed by user accordingly.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

@yashag2255 

Thanks for the solution. It works for me in edit mode but when I play the App, the form was blank.

 

 

Hi  @yashag2255 

 

Could you please have a look at my problem. PLease let know as soon as possible.

 

Link : https://powerusers.microsoft.com/t5/Building-Power-Apps/Sharepoint-gt-Powerapps-gt-Outlook/m-p/45586... 

 

Regards,
Sanket

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,989)