Forum Discussion

cj_sh's avatar
cj_sh
Regular Visitor
6 years ago
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.    
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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"

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi cj_sh ,

 

The easiest way to achieve this is Conditional Columns in Power Query. 

Please Use Operator as contains or Equal according to your other options.

Please use the attached picture as reference.

 

Best Regards,

Gaurav Raj Singh