How to use search and add columns in filter

(0) Share

Report

Posted on by SumanKoduri

243

I'm getting error when I try to use search and add columns together

 Filter(
 Search(
 '[GLOBUS_APP].[T5006_RETURNS_LOG]',
 TextSearchBox2.Text,
 "C5006_SENDER_NAME",
 "C5006_COMMENTS",
 "C5006_TRACKING_NUMBER",
 "C506_RMA_ID"
 ),
 AddColumns(
 '[GLOBUS_APP].[T5006_RETURNS_LOG]',
 "dateoffset",
 Text(
 DateAdd(
 C5006_RETURN_LOGGED_DT,
 TimeZoneOffset(),
 Minutes
 ),
 "[$-en-US]mm-dd-yyyy"
 ),
 DateValue(dateoffset) >= StartDate.SelectedDate,
 DateValue(dateoffset) <= EndDate.SelectedDate
 )
 )

How to change this code?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@SumanKoduri

You're getting an error because your Filter syntax is incorrect. Filter needs, DataSource and Conditions. In your formula you are providing two data sources - not valid.

Try this instead:

AddColumns( Search( Filter('[GLOBUS_APP].[T5006_RETURNS_LOG]', DateValue(dateoffset) >= StartDate.SelectedDate, DateValue(dateoffset) <= EndDate.SelectedDate ), TextSearchBox2.Text, "C5006_SENDER_NAME", "C5006_COMMENTS", "C5006_TRACKING_NUMBER", "C506_RMA_ID" ), "dateoffset", Text( DateAdd(C5006_RETURN_LOGGED_DT, TimeZoneOffset(C5006_RETURN_LOGGED_DT), Minutes), "[$-en-US]mm-dd-yyyy" ) )

This will Filter your datasource by the date range, then search the results of that, then add the column dateoffset to the results of that.

I hope this is helpful for you.

Was this reply helpful? Yes No
SumanKoduri 243 on at

Like (0)

Report
Copy link

Link copied!
it is showing error date value as invalid arguments

I tried like this
Filter( AddColumns( '[GLOBUS_APP].[T5006_RETURNS_LOG]', "dateoffset", Text( DateAdd( C5006_RETURN_LOGGED_DT, TimeZoneOffset(), Minutes ), "[$-en-US]mm-dd-yyyy" ) ), DateValue(dateoffset) >= StartDate.SelectedDate, DateValue(dateoffset) <= EndDate.SelectedDate, TextSearchBox2.Text in C5006_SENDER_NAME || TextSearchBox2.Text in C5006_COMMENTS || TextSearchBox2.Text in C5006_TRACKING_NUMBER || TextSearchBox2.Text in C506_RMA_ID )

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@SumanKoduri

If you're using those dates for comparison, you might want to consider this formula instead:

Filter( AddColumns( '[GLOBUS_APP].[T5006_RETURNS_LOG]', "dateoffset", DateAdd( C5006_RETURN_LOGGED_DT, TimeZoneOffset(), Minutes ) ) ), dateoffset >= StartDate.SelectedDate, dateoffset <= EndDate.SelectedDate, TextSearchBox2.Text in C5006_SENDER_NAME & C5006_COMMENTS & C5006_TRACKING_NUMBER & C506_RMA_ID )

Also, tightened up the TextShearchBox bit in the filter. Since you are || (Or'ing) each field, you might find it easier to just concatenate them all together and see if the search text is in the combined string. Totally optional...

Was this reply helpful? Yes No