Thx!
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.
