I am struggling with an App where I get info from a sharepoint list. I first have two dropdown lists which works fine. Then the two next controlls really doesn't need to be drop downs, but rather text boxes that get information the same way from the sharepoint list as the drop downboxes. But what type of controll/text box can be used? And is it possible to wrap the text in the drop down box? It also seems like only the first 1,5 line of the text is shown in the drop down box (example below Artikkelnr).
I use the formula: Sort(Distinct(Filter('Leveringsevne langsiktig', Produkt=Dropdown_Produkt.Selected.Value), Artikkel), Result) for the "Artikkelnr" Drop down box.
Solved! Go to Solution.
Could you please share a bit more about your scenario?
Do you want to use a Dropdown control to display the Artikkelnr Column value?
Further, do you want the whole Text value within the Artikkelnr Column could be displayed within the Dropdown control?
I have made a test on my side, if you want the whole Text value within the Artikkelnr Column could be displayed within the Dropdown control, I afraid that there is no way to achieve your needs in PowerApps currently.
In addition, you could also consider take a try to use the Rich Text Editor control to display the Artikkelnr Column value instead of Dropdown control. I have made a test on my side, please take a try with the following workaround:
Note: Please remove the Original Text Input box from the Artikkelnr Data card firstly, then add a Rich Text Editor control within it.
I actually don't want to use a drop down for the Artikkelnr, but I don't know what to use instead..
If you look at the snap from the sharepoint list (also attached as excel) the first drop down in the App make you choose the market area. The second drop down is filtered based on the market are input.
As an example: If you choose Area 1 in the drop down, you can select between different products. But if you select Prod 20,21,22... you see that in column C there is only one line (Item# 20,21,22,...), and in columns D-G the same.
In drop down "Markedsområde" I use the following formula: Distinct('Leveringsevne langsiktig',Markedsområde), and in drop down "Produkt" I use this formula: Sort(Distinct(Filter('Leveringsevne langsiktig', Markedsområde= Dropdown_Markedsområde.Selected.Value),Produkt), Result)
In addition I use DisplayMode(fx)=If(Dropdown_Markedsområde.Selected.Value = "", DisplayMode.Disabled, DisplayMode.Edit) to force the user to choose "Markedsområde" first.
Now I have used drop down (as a work around) for "Artikkelnr", "Beskrivelse", "Fra", and "Til", and just set DisplyMode (fx)=If(Dropdown_Markedsområde.Selected.Value = "", DisplayMode.Disabled, DisplayMode.View) to hide the drop down menu. But then I get the issue with wrapping of text. It's not an elegant solution if better options exists.
Can I use the Rich text editor to show the information from the associated cell from column C-G?
I tried but didn't find the formula to use.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.