cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

Re: Getting errors, changed my application from Excel to SharePoint

It only works like this:

I removed all the columns instead of Ordernummer and now it works. But I want the others to be in there too. @v-bofeng-msft 

The column Status should now work too. As I am using in the first bit too and it gives no error.

 

    Search(
        If(
            gblIsAdmin,
            'Manco-Informatie',
            Filter(
                'Manco-Informatie',
                Verzender = VarCurrentUser.FullName && If(
                    selectedStatus <> "All",
                    IsBlank(selectedStatus) || Status = selectedStatus
                )
            )
        ),
        TekstZoekVeld.Text,
        "Ordernummer"
    )

 


 

Highlighted
Post Prodigy
Post Prodigy

Re: Getting errors, changed my application from Excel to SharePoint

 
Highlighted
Microsoft
Microsoft

Re: Getting errors, changed my application from Excel to SharePoint

Hi @TimoMigchielsen :

In some region, “; represent ,, ;;, represent ;”,if used incorrectly they cause errors

Based on your code, I find that you sometimes use“;” sometimes“,”.

Chould you tell me:

How the separator is used in your area?

Best Regards,

Bof

Highlighted
Post Prodigy
Post Prodigy

Re: Getting errors, changed my application from Excel to SharePoint

I think I have to use a , for my code. Now this code worked but I can't add any other columns, do you maybe know why? @v-bofeng-msft @RandyHayes 

    Search(
        If(
            gblIsAdmin,
            'Manco-Informatie',
            Filter(
                'Manco-Informatie',
                Verzender = VarCurrentUser.FullName && If(
                    selectedStatus <> "All",
                    IsBlank(selectedStatus) || Status = selectedStatus
                )
            )
        ),
        TekstZoekVeld.Text,
        "Ordernummer"
    )

  

Highlighted
Microsoft
Microsoft

Re: Getting errors, changed my application from Excel to SharePoint

Hi @TimoMigchielsen :

Can you tell me :

Have you replaced ";" with "," in this code ?

1.PNG

Have you tested field names other than “Ordernummer”?

In addition,I think this link will help you a lot.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

Best Regards,

Bof

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (8,334)