Answered

Help with filters for a sharepoint based application in power apps

(0) Share

Report

Posted on by BMERP

I have generated an application in power apps starting from a sharepoint list with multiple columns, in the initial grid of the application I have the following code, where the values of my columns are shown based on the selected:

SortByColumns(

Filter(

[@ListaSoporte];

StartsWith(

Empresa;

TextSearchBox1.Text

)

);

"ID";

If(

SortDescending1;

SortOrder.Descending;

SortOrder.Ascending

)

The problem comes when I want to add another parameter to this filter so that it only shows the results whose value in a Choice column is equal to (Process).

Im triying with this code:

SortByColumns(
    Filter(
        Filter(
            [@ListaSoporte];
            StartsWith(
                Empresa;
                TextSearchBox1.Text
            )
        );
        Estado.Value="Proceso"
    );
    "ID";
    If(
        SortDescending1;
        SortOrder.Descending;
        SortOrder.Ascending
    )
)

And it does not show errors but it does not return data, I would like to make this code as simple as possible.

Any help or suggestions on how I can do with the code?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@BMERP ,

I think the below is what you're trying to do? You do not need to nest the Filter function.

SortByColumns( Filter( ListaSoporte; StartsWith( Empresa; TextSearchBox1.Text ); Estado.Value="Proceso" ); "ID"; If( SortDescending1; SortOrder.Descending; SortOrder.Ascending ) )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
BMERP 21 on at

Like (0)

Report
Copy link

Link copied!

Tried with that code but nothing, its not returning any data.

Algo when i try with some other codes im getting the error "cant compare diferent types Record/Text"

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@BMERP - as I understand it, you do not receive any errors with the expression I provided, and the problem only occurs when you include the "Estado" field as an additional parameter in your Filter.

Could you confirm the Estado is a single choice field, and share a screenshot of your table if possible.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @BMERP - I am glad my suggested solution solved the problem, but it would be worth clarifying why it was not working for you the first time. This will help other community users who may experience the same problem.

Was this reply helpful? Yes No
BMERP 21 on at

Like (1)

Report
Copy link

Link copied!

The code you provided was fine, the error was in my sharepoint list because it was missing refreshing the values of the choice column.... all the values were in the "Solved" state, that's why it was not showing any data.

Was this reply helpful? Yes No