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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
30,510
