You’re offline. This is a read only version of the page.
Hello,
Is it possible to replace or erased a text field with a condition IF formula?
I tried using the following syntax. It does display "Vacant"; however, the source data in SharePoint list still shows the original employee name and not the text Vacant. Is there a way to actually replace the original value with Vacant.
The syntax is used on the text property for Employee.
If(ThisItem.Status = "Vacant","Vacant",ThisItem.Employee)
Any help would be greatly appreciated.
So after using If(ThisItem.Status = "Vacant","Vacant",ThisItem.Employee) on the update property on the employee data card I am unable to reverse the process. If I change the status to Active and manually change the employee name, the Vacant text remains and won't reflect the new name. I'm not sure why that is.
Ok, then you want to use it as the Update property of your Employee card. Once you Submit the form, the Employee name should change if the status is "Vacant".
Ok, then you want to use it as the Update property of your Employee card. Once you Submit the form, the Employee name should change if the status is "Vacant".
Correct. I have a form for updating records. The objective is to change the status and auto populate or remove certain data from a field
Please provide the context, are you using it in a form?
It works fine on the display but the actual data in my share point list still still shows the original text(the employee name) not the replaced text vacant I want
When I tested your formula in my gallery, it worked fine.
Single line text
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (