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,
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
184 | |
53 | |
50 | |
36 | |
34 |
User | Count |
---|---|
270 | |
91 | |
82 | |
76 | |
75 |