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

[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?

[TJO]

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

[v-yutliu-msft · Accepted solution]

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,