Comparison in If Statement

(0) Share

Report

Posted on by Dhinesh28R

599

Hi,

Am comparing values in If function like following,
If(Concat(List.ID,Text(ThisRecord.ID),";") in Concat(col.CID,Text(ThisRecord.CID),";"),"True","False").

Here Concat(List.ID,Text(ThisRecord.ID),";") Getting values 1;2;3;4;5.
Concat(col.CID,Text(ThisRecord.CID),";") Getting value 5.

It always getting false.

But i need a Answer True. My if function is Correct or Wrong? What to do?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Dhinesh28R swap them around,
If(Concat(col.CID,Text(ThisRecord.CID),";") in Concat(List.ID,Text(ThisRecord.ID),";"),"True","False")

Was this reply helpful? Yes No
Dhinesh28R 599 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CNT ,
Its working man.
But i have a doubt?
If i put "in" means Its getting true.
If i put "=" means its getting false.

If suppose to i put "=" means how to get true man?

Thanks.

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Dhinesh28R '=' means exact match whereas 'in' doesn't have to be a exact match but as long as it's in there it's fine.

Please remember to give a 👍 and accept the solution as it will help others in the future.

Was this reply helpful? Yes No
Dhinesh28R 599 on at

Like
a
(0)

Report
Copy link

Link copied!

@CNT , Okay man.
If suppose i want this 1;2;3;4 is Like following,
1
2
3
4
What to do? i use split but it doesn't work.

Thanks.

Was this reply helpful? Yes No