Forum Discussion
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")
)
- Anonymous4 years ago
HI RonaldvdH,
According to your description, it seems like your formulas are more related to 'power apps', I'd like to suggest you post these to the power app community to get further support.
Power Apps Community - Power Platform Community (microsoft.com)
Here is the official document about sortbycolumns function usages, you can check it if helps:
Sort and SortByColumns functions in Power Apps - Power Apps | Microsoft Docs
Regards,
Xiaoxin Sheng
2 Replies
- AnonymousNot applicable
HI RonaldvdH,
According to your description, it seems like your formulas are more related to 'power apps', I'd like to suggest you post these to the power app community to get further support.
Power Apps Community - Power Platform Community (microsoft.com)
Here is the official document about sortbycolumns function usages, you can check it if helps:
Sort and SortByColumns functions in Power Apps - Power Apps | Microsoft Docs
Regards,
Xiaoxin Sheng
- RonaldvdH
Post Patron
Oeps....my bad, was working on both communities last week so I guess I wasn't paying attention. I've posted my question on the right forum, thanks for letting me know