Answered

How can i patch a SharePoint list blank based on a condition?

(0) Share

Report

Posted on by patricia_r

Hello,

Hope i can get help with this. I have a SP list call employees that i am using, then i am using a label to show the age. When i want to patch employee email and Age i would like for Age to be as blank/Null how can i do this base on a condition.

On the Text property i have a lookup formula

LookUp(Employees, EmployeeEmail=Dropdown2.Selected.EmployeeEmail,Age)

What can i put on the Submit Button?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

TJO 230 on at

Like
a
(0)

Report
Copy link

Link copied!

@patricia_r How about you try with an UpdateIf() formula?

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @patricia_r ,

Do you want to update items that EmployeeEmail=Dropdown2.Selected.EmployeeEmail with blank age?

If so, I agree with @TJO to use UpdateIf() function, which could update all the items that meet the requirement.

Firstly, please change this setting in your app:
File->settings->advanced settings->turn this toggle on

Then use formula like this to update:

UpdateIf(datasourcename,EmployeeEmail=Dropdown2.Selected.EmployeeEmail,{Age:Blank()})

Best regards,

Was this reply helpful? Yes No