Forum Discussion
Solved
Finding fix text in the string
I am fetching data from SharePoint list. Requirement: there is a string, from which I need to find two fix words (AD and PC), and send the finding into a new column.
Hi cj_sh ,
You could add if() function to return the results you want.
if Text.Contains([Column1],"PC")=true then [Column1] else "Your other result"
mussaenda Thanks, I don't know why my query editor is not showing ContainsString function among the choices.
but I am trying Text.Contains([ColumnName],"AD"), and it is giving me True/False whereever AD in the string.
Now I am getting challenge in value AD in the column instead of True.
Can you help me in that..
v-eachen-msft
Community Support
Community SupportHi cj_sh ,
You could add if() function to return the results you want.
if
Text.Contains([Column1],"PC")=true
then
[Column1]
else
"Your other result"