topic Re: Find a replace a string based on the value of another string in App Development

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

aantunesp — Mon, 14 Mar 2022 12:55:57 GMT

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_ — Mon, 14 Mar 2022 13:35:33 GMT

Try this:

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

aantunesp — Mon, 14 Mar 2022 14:39:18 GMT

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

Many thanks !! 🙂