Unanswered

Set a variable from an empty cell in a SherePoint list.

(0) Share

Report

Posted on by Brohormr

Hi,

I want to set a variable in the visible fx of a label. If a cell in a SharePoint list is empty the label must become visible.

I tried this but it's didn't work.

Set(
 var_tag;
 If(
 LookUp(
 GEN_TEXTE_CREATICK_DATA;
 'Nom du poste' = TextInput2.Text;
 'Tag Nexthink d'exclusion des non-conformités') <> "";
 true
)

Anyone can help me ?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Brohormr ,

I just modified my code.
Please try this:

If(IsBlank(LookUp(GEN_TEXTE_CREATICK_DATA;'Nom du poste' = TextInput2.Text).'Tag Nexthink d'exclusion des non-conformités');Set(var_tag;true);Set(var_tag;false))

Hope this helps you!
-----------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Brohormr 8 on at

Like (0)

Report
Copy link

Link copied!

It say missing operator.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Brohormr ,

Are you trying my modified code?

If(IsBlank(LookUp(GEN_TEXTE_CREATICK_DATA;'Nom du poste' = TextInput2.Text).'Tag Nexthink d'exclusion des non-conformités');Set(var_tag;true);Set(var_tag;false))

Was this reply helpful? Yes No
Brohormr 8 on at

Like (0)

Report
Copy link

Link copied!

Yes but it return (translated from french) An operator was intended +, * or & at this step of the formula.

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Brohormr ,

Could you provide a screenshot of the code so I can know where the error is in the code?

Was this reply helpful? Yes No
Brohormr 8 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Brohormr ,

If you want to set the value of 'var_user' to:'Utilisateur CMDB'&"ad"&'var_tag'.
Please try this:
If(IsBlank(LookUp(GEN_TEXTE_CREATICK_DATA;'Nom du poste' =InputNomPC.Text).'Tag Nexthink d'exclusion des non-conformités');Set(var_tag;true);Set(var_tag;false)); Set(var_user;LookUp(GEN_TEXTE_CREATICK_DATA;'Nom du poste' = InputNomPC.Text).'Utilisateur CMDB'&"ad"&var_tag)

Hope this helps you!
-----------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Brohormr 8 on at

Like (0)

Report
Copy link

Link copied!

No I want to set two different variables from the same on select but they are not linked.

var_user is a variable which I use other else to define the mail adress of the user (it's ok).
var_tag is to set visible a label if a cell of a specific column is empty. (not ok)

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Brohormr ,

Well, it seems that the method I provided at the beginning is correct, the code is fine in my test and there is no error in the code in your screenshot, does the error appear when you click the button? By the way, did you try to enter some values into the text input? I hope you can attach some screenshots of the test results about 'var_tag'.

Best regards,
Rimmon Li

Was this reply helpful? Yes No