You’re offline. This is a read only version of the page.
36
Hi Guys - I wonder if anyone can help with the below error message? The app works fine when the error message is cleared. I know it has something to the code below that I have in the Area field... Both the area and store data are taken from a different source from the rest of the fields and the store field is dependent on the area field selected.
The code I have in the area field is
Share
ReportSortByColumns(Distinct(Table2,Area),"Result")
Any help to resolve would be greatly appreciated.
Hello,
i have a similar problem with this string:
Filter(Lagerbestand;Kunde=Dropdown1_1.SelectedText.Value)
andthis:
LookUp(Lagerbestand;Bezeichnung=Dropdown1_2.SelectedText.Value).Teilenummer
but I am too stupid to adapt the If function to my code 😞
In both cases, I am refering to an "earlier" dropdown. My table is in excel.
I think the first solution is suitable for me, maybe someone could help me with the If funktion?
Try this:
All responses (
Answers (
If(IsBlank(DD_Area.Selected.Result),SortByColumns(Distinct(Table2,Site),"Result"),
SortByColumns(Distinct(Filter(Table2,Area = DD_Area.Selected.Result),Site),"Result"))
or this and let me know if you get your desired result:
If(!IsBlank(DD_Area.Selected.Result),SortByColumns(Distinct(Filter(Table2,Area = DD_Area.Selected.Result),Site),"Result"))
Stay up to date on forum activity by subscribing.
#1
stampcoin
86
#2
DS-11051211-0
20
#3
MS.Ragavendar
9