Answered

If statement Record comparison

(0) Share

Report

Posted on by Evolve809

Good morning all

please lend me a hand with this, ive tried all and some, I need to compare a record to record value and am pulling my hair out...

Set(varTT,Gallery1.Selected.Status);
Set(varTTT,{Status:{Value:"Production"}});

If( varTT = varTTT, true, false)

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-jefferni on at

Like (1)

Report

Hi @Evolve809 ,

Please try:

varTT.Value = varTTT.Status.Value

if statement is not needed here.

Best regards,

Was this reply helpful? Yes No
Evolve809 9 on at

Like (0)

Report

Thanks for the quick response!

Let me give you the followup in the if statement...

Set(varTT,Gallery1.Selected.Status);
Set(varTTT,{Status:{Value:"Production"}});

If( varTT = varTTT ,Patch('Job Card Clients',GalleryClients.Selected,{'Total Time':Text(varTot)}),Patch('Job Card Exchange Units',GalleryEX.Selected,{'Total Time':Text(varTot)}));

As you can see I need to patch two different lists depending on the validity of the if statement outcome.

Does your suggested solution have outcome options?

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @Evolve809 ,

The expression varTT.Value = varTTT.Status.Value returns true or false just like in a If statement.

Actually, the two variables are not needed either:

If(Gallery1.Selected.Status.Value = "Production" ,Patch('Job Card Clients',GalleryClients.Selected,{'Total Time':Text(varTot)}),Patch('Job Card Exchange Units',GalleryEX.Selected,{'Total Time':Text(varTot)}));

Best regards,

Was this reply helpful? Yes No
Evolve809 9 on at

Like (0)

Report

Thanks!! Ya the variables was part of a vailed attempt in all honesty.
It's thank goodness not erroring but for some reason its not patching to a one of the lists? You maybe have a smart plan to correct that?

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @Evolve809 ,

I suspect it's due to the limitation of If function. Is it possible that using 2 buttons, each for patching to one data source? You can control the visibility of the two buttons on the condition above:

to clients button:

Patch('Job Card Clients',GalleryClients.Selected,{'Total Time':Text(varTot)})

Visible:

Gallery1.Selected.Status.Value = "Production"

to exchange units button:

Patch('Job Card Exchange Units',GalleryEX.Selected,{'Total Time':Text(varTot)})

Visible:

!(Gallery1.Selected.Status.Value = "Production")

Best regards,

Was this reply helpful? Yes No
Evolve809 9 on at

Like (0)

Report

Thanks as a last resort I can build that solution in.
alternatively, is it possible to patch to the initial combined gallery?
The split galleries are just incorporated on a screen that cant be seen at all in an attempt to do the if statement thing.
If I can patch to the combined data that'll be first first prize!!
Thanks sooo much for your help.

Was this reply helpful? Yes No