cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

PowerApps Update error?

Hello Everyone,

 

I accessed the application I'm developing on Monday and everything was working normally.

I accessed it again today because some modifications were requested and I had some problems ...


it is a List where we can view all registered records from a sharepoint list.

 

in my code it causes the list to be visualized and can be filtered between data pickers and another column Locations (USA, CA, MX, ALL) and filter by a text box.

 

Obs: I tried to go back to an old version but I still have the same problem in all versions.

 

 

it should work like this:

 

JotaJr_1_0-1602093796096.png

 

Code:

 

 

If(
    ListSearchBox_BA.Text <> ""
    Sort(
        Search(
            Lista_BP_System;
            ListSearchBox_BA.Text;
            "Grupo";
            "Planta";
            "PalavraChave";
            "Departamento";
            "Classifica_x00e7__x00e3_o";
            "SubClassifica_x00e7__x00e3_o";
            "Solicitante"
        );
        Criado;
        If (
            varSort = "Asc";
            Descending;
            Ascending
        )
    );
    If(
       DropPlanta.Selected.Result = "ALL";
       
       Filter(
            Lista_BP_System;
            Value(
                Substitute(
                    'Data Ref';
                    "/";
                    ""
                )
            ) >= Value(Month(DatePickerStart.SelectedDate) & Year(DatePickerStart.SelectedDate)) && Value(
                Substitute(
                    'Data Ref';
                    "/";
                    ""
                )
            ) <= Value(Month(DatePickerEnd.SelectedDate) & Year(DatePickerEnd.SelectedDate))
        );

        SortByColumns(
            Filter(
                Lista_BP_System;
                (Planta = DropPlanta.Selected.Result);
                Value(
                    Substitute(
                        'Data Ref';
                        "/";
                        ""
                    )
                ) >= Value(Month(DatePickerStart.SelectedDate) & Year(DatePickerStart.SelectedDate)) && Value(
                    Substitute(
                        'Data Ref';
                        "/";
                        ""
                    )
                ) <= Value(Month(DatePickerEnd.SelectedDate) & Year(DatePickerEnd.SelectedDate))
            );
            "DataRef";
            If (
                varSort = "Asc";
                Descending;
                Ascending
            )
        )
    )
)



 

 

 

1 REPLY 1
Community Support
Community Support

Hi @JotaJr_1 ,

 

What is Error Message? Which part of code turns red? Please share more details.

Sik

 

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (39,096)