Forum Discussion

RonaldvdH's avatar
RonaldvdH
Icon for Post Patron rankPost Patron
4 years ago
Solved

Error in my filter and SortByColumns

Hello,

 

Ive got an error in my Filter when I add the SortByColumns function. I can't find out why and this formula works in another app.

I think something is wrong with the column on which it has to sort ("Title")  but I'm not sure

 

If(
    DD_Opdrachtgever.Selected.Result= Blank() And DD_Hoofdproject.Selected.Result = Blank();
    SortByColumns('Hoofdprojecten';"Title");
    DD_Opdrachtgever.Selected.Result= Blank() And DD_Hoofdproject.Selected.Result <> Blank();
    SortyByColumns(Filter('Hoofdprojecten';Hoofdproject=DD_Hoofdproject.Selected.Result);"Title");
    DD_Opdrachtgever.Selected.Result<> Blank() And DD_Hoofdproject.Selected.Result = Blank();
    SortyByColumns(Filter('Hoofdprojecten';Opdrachtgever.Value=DD_Opdrachtgever.Selected.Result);"Title");
    DD_Opdrachtgever.Selected.Result<> Blank() And DD_Hoofdproject.Selected.Result <> Blank();
    SortyByColumns(Filter('Hoofdprojecten';Opdrachtgever.Value =DD_Opdrachtgever.Selected.Result And Hoofdproject = DD_Hoofdproject.Selected.Result);"Title")
)

 

2 Replies