Unanswered

error on equal sign

(0) Share

Report

Posted on by sbrenazmzri

Hi, i wanted to filter by column status = completed, but my syntax having an error on equal sign. tq

If(
IsBlank(varSortColumn)||IsBlank(varSortDirection),
Filter(
ReportDetailsTable,
StartsWith(ID,SearchInputBox.Text) && 'Created By'.Email = VarLoggedInUser && Status = "Completed"
),
Sort(
Filter(
ReportDetailsTable,
StartsWith(ID,SearchInputBox.Text) && 'Created By'.Email = VarLoggedInUser && Status = "Completed"
),
Switch(
varSortColumn,
"ID",
ID
),
varSortDirection
)
)

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sbrenazmzri,

I am assuming your status column is of type choice and you are wanting to filter the status using a dropdown control?

Please try:
'Status Option' = Dropdown1.Selected.Value

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C
sbrenazmzri 6 on at

Like
a
(0)

Report
Copy link

Link copied!

actually i didnt set status option as dropdown, im trying to get the value 'completed' directly from the list.
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sbrenazmzri,

Can you please provide what column type Status is. Is it of type choice, text?
sbrenazmzri 6 on at

Like
a
(0)

Report
Copy link

Link copied!

yes.. the column type for status is choice, sorry i didnt say it earlier
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sbrenazmzri,

Try putting:
Text(Status) = "Completed"

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C
WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@sbrenazmzri ,

You actually need Status.Value, but the main reason for my post is to suggest a better structure which allows for any sort field

With( { _Data: Filter( ReportDetailsTable, StartsWith( ID, SearchInputBox.Text ) && 'Created By'.Email = VarLoggedInUser && Status.Value = "Completed" ) }, If( IsBlank(varSortColumn) || IsBlank(varSortDirection), _Data, SortByColumns( _Data, varSortColumn, varSortDirection ) ) )
Srirangamnipun 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sbrenazmzri ,

If it is choice column in sharepoint, then use status.Value="Completed"
Thank You.