Answered

Lost with LOOKUP function & AND function

(0) Share

Report

Posted on by arthurbeaulieu

Hi,

I'm updating an app for more security in it.
I have some trouble with a formula :

If(IsBlank(DataCardValue14) And LookUp(ADMINISTRATIF; DataCardValue12.Text in 'S/N PC'; DataCardValue12.Text) = DataCardValue12.Text

;SubmitForm(EditForm1); UpdateContext({Alert: true}));;Clear(SplitScan)

So in english i would like something like :

If datacard14 is blank and in the colum S/N PC of my "administratif" table there is the same value than in datacardvalue 12
then update alert on true

if not submit form

(clearscan is independant)

hope someone have an good idea with that.

(it's an app for inventory because we are tired of GLPI and other)

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
can you please let me the the column which you want to compare with datacardvalue12 and the column type - text, choice, multi select choice, user, etc
in the below formula you will have to replace columnName with that column
If(IsBlank(DataCardValue14) And LookUp(ADMINISTRATIF; DataCardValue12.Text in 'S/N PC'; ColumnName) = DataCardValue12.Text
;SubmitForm(EditForm1); UpdateContext({Alert: true}));;Clear(SplitScan)
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @arthurbeaulieu,

Do you want to check if the DataCardValue12 text exists in the 'S/N PC' column from your ADMINISTRATIF table?

If so, I think you could directly compare the DataCardValue12 text with 'S/N PC' column using the "=" operator as below:

If(IsBlank(DataCardValue14.Text) And IsBlank(LookUp(ADMINISTRATIF; DataCardValue12.Text = 'S/N PC')) ;SubmitForm(EditForm1); UpdateContext({Alert: true}));;Clear(SplitScan)
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@arthurbeaulieu

I agree with @v-qiaqi-msft , almost

If(IsBlank(DataCardValue14.Text) And IsBlank(LookUp(ADMINISTRATIF; DataCardValue12.Text = 'S/N PC'))
;SubmitForm(EditForm1));;

Clear(SplitScan)

Move UpdateContext({Alert: true}) to the OnSuccess property of the form so it doesn't execute until the form is submitted successfully. Consider moving the Clear(SplitScan) too if it's also a condition of the successful submission.
Verified answer

arthurbeaulieu 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi everyone thanks for your reply. I finally find something that work :

If(LookUp(ADMINISTRATIF; DataCardValue12.Text in 'S/N PC'; "OK") <> "OK" || LookUp(ADMINISTRATIF;DataCardValue14.Text in ID; "OK") = "OK"
;SubmitForm(EditForm1); Set(varquit;UpdateContext({Alert:true})));;Clear(SplitScan)

Everything is working fine