Answered

put a code that checks in the sharepoint list if the address exists and that it retrieves the email address from another column

(0) Share

Report

Posted on by Shekinah

Bonjour, mettez un code qui vérifie dans la liste SharePoint si l'adresse existe et qu'il récupère l'adresse mail d'une autre colonne, si elle n'existe pas il garde l'adresse mail du libellé.
voici mon code, mais cela ne répond pas

Categories:

Building Power Apps

2023-05-21_19-43-...

I have the same question (0)

All responses (3)

Answers (1)

Shekinah 48 on at

Like (0)

Report

If(Label30.Text=LookUp('AppACL-Tutelle2';Title=Label30.Text;Title); If(!IsEmpty(LookUp('AppACL-Tutelle2';Title=Label30.Text;Interimaire)); LookUp('AppACL-Tutelle2';Title=Label30.Text;Interimaire.Email);Label30.Text);Label30.Text)

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @Shekinah,

Could you please share a bit more about your scenario?

Do you want to retrieve the email address from the Interimaire if Interimaire is not null?

To check a field value, you need to use the IsBlank() instead, and please modfiy as below:

If(Label30.Text=LookUp('AppACL-Tutelle2';Title=Label30.Text;Title)&& !IsBlank(LookUp('AppACL-Tutelle2';Title=Label30.Text;Interimaire)); LookUp('AppACL-Tutelle2';Title=Label30.Text;Interimaire.Email); Label30.Text )

Was this reply helpful? Yes No
Shekinah 48 on at

Like (0)

Report

Oh thank you

Was this reply helpful? Yes No