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?
Solved! Go to 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,
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,
User | Count |
---|---|
172 | |
90 | |
74 | |
69 | |
58 |
User | Count |
---|---|
215 | |
160 | |
98 | |
92 | |
73 |