Find a replace a string based on the value of another string

[aantunesp]

Hi,

I want to replace some field names based on the value of another field.

for example I have a list of users ids and I want to replace the user name by "internal" if the User type is = "Internal".

How can I achieve it?

Thanks in advance

[Iswarya_ · Accepted solution]

Hi @aantunesp ,

Try this:

If(UserType='Internal','Internal',Username) as Username

[aantunesp]

Hi @Iswarya_ 

It works but I need to remove the as Username otherwise the syntax validation gives a error.

Many thanks !! 🙂