How to filter and search in power apps

(0) Share

Report

Posted on by rodzmaz81

202

Hi All

Please help I have made changes to restrict my app showing information to a user based on a default branch now my issue is

1.I need to search multiple columns after the status of incident and it should search by Location ,Injury classification ,on site/offsite etc : Filter('[rp].[Form InjuriesOnDutyF]',Siteofincident = varBranch && 'txt.InjuriesOnduty.Text'.Text in StatusOfincident)

2.I need to sort the results in descending order using an Id number which is incremental number so that it sorts the last number created/ saved first below it must 16 then15

Filter('[rp].[Form InjuriesOnDutyF]',Siteofincident = varBranch && 'txt.InjuriesOnduty.Text'.Text in StatusOfincident),Id,Descending)

the above just wont work ,i tried to add a sortbycolumn with no luck. Filter issue.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Use
Sort(Filter('[rp].[Form InjuriesOnDutyF]',Siteofincident = varBranch && 'txt.InjuriesOnduty.Text'.Text in StatusOfincident),Id,Descending)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
rodzmaz81 202 on at

Like (0)

Report
Copy link

Link copied!

@eka24 thanks can you also me with search of multiple columns including Status Of incident part Filter('[rp].[Form InjuriesOnDutyF]',Siteofincident = varBranch && 'txt.InjuriesOnduty.Text'.Text in StatusOfincident)

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

use:
Filter(Search('[rp].[Form InjuriesOnDutyF]',Siteofincident ,txt.InjuriesOnduty.Text,"StatusOfincident","Column2","Column3"),Siteofincident=varBranch )
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Are you ok with the Search
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
rodzmaz81 202 on at

Like (0)

Report
Copy link

Link copied!

@eka24 not yet I still get errors
I even tried Filter(Search('[rp].[Form InjuriesOnDutyF]',Siteofincident,txt.InjuriesOnduty.Text,"COIDclaimnumber","BodyPart"),Siteofincident=varBranch )

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Please look at the formula very well.
What is the name of the search Text box,
Change SearchTextBox to the name of your search Textbox

Filter(Search('[rp].[Form InjuriesOnDutyF]',Siteofincident,SearchTextBox.Text,"COIDclaimnumber","BodyPart"),Siteofincident=varBranch )

Was this reply helpful? Yes No
rodzmaz81 202 on at

Like (0)

Report
Copy link

Link copied!

@eka24 not sure what is happening i gor an error i renamed the SearchBox I got an error

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Please check the spelling of the column names if they are all ok. The formula looks fine
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
rodzmaz81 202 on at

Like (0)

Report
Copy link

Link copied!

@eka24 Thank you so much

Was this reply helpful? Yes No