Error when copy IF function result in datacardvalue

Like (0) Share

Report

Posted on 9 Sep 2021 11:41:18 by luisep

105

Hi,

I'm trying to copy the result of a IF function result.

My scenario:

Gallery1 - Label1
Form1 - Datacardvalue1

Label2 (outside Galley1 and Form1): If (Label1.Text = Datacardvalue1.Text; "Yes";"Updates")

My problem is when I try to copy the result of Label2 in Datacardvalue2 a circular reference error appear. Same if a put "

If (Label1.Text = Datacardvalue1.Text; "Yes";"Updates")" in Datacardvalue1.

Is there any way to convert Label2 (boolean) to Text? Or to solve this circular reference directly in Datacardvalue1?

Thanks,

Categories:

General Questions

I have the same question (0)

All responses (4)

Answers (0)

luisep 105 on 10 Sep 2021 at 22:18:28

Like (0)

Report

Re: Error when copy IF function result in datacardvalue

Hi @PriyankaGeethik ,
I'll try to explain it in more detail:

Gallery1: Items: Filter(SPlist1,Reference=Datacardvalue1)
Label1: ThisItem.Reference
Label2: ThisItem.Description

Form1: Items: SPlist2
Datacardvalue1: ThisItem.Reference
Datacardvalue2: ThisItem.Description
Datacardvalue3: If(Label1.Text = Datacardvalue1.Text,'Yes','Updated')

Error in Datacardvalue3: circular reference.

Thanks,

Label 2: If(Label1.Text = Datacardvalue1.Text; "Yes";"Updated")

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on 10 Sep 2021 at 18:33:15

Like (0)

Report
Re: Error when copy IF function result in datacardvalue

Hi @luisep ,

Not sure if I understood it correctly or not.
From the formula you used above something like below might work in your case.
If Label 2 is inside gallery : If(Thisitem.Description=Gallery.Selected.Description; "Yes";"Updated")

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
luisep 105 on 09 Sep 2021 at 14:08:03

Like (0)

Report

Re: Error when copy IF function result in datacardvalue

Hi @PriyankaGeethik,

These are default formulas I've used:
Gallery1: Items: SPlist1
Label 1: ThisItem.Description

Form1: Items: SPlist2
Datacardvalue1: Thisitem.Description
Datacardvalue2: If(Label1.Text = Datacardvalue1.Text; "Yes";"Updated")

Label 2: If(Label1.Text = Datacardvalue1.Text; "Yes";"Updated")

Thanks,

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on 09 Sep 2021 at 12:00:11

Like (0)

Report

Re: Error when copy IF function result in datacardvalue

Hi @luisep ,

Please explain the default formula used in below controls.

Label 1
Label 2
Datacardvalue1
Datacardvalue2

Was this reply helpful? Yes No