Conditional formatting using lookup column

Copper Contributor

I have a lookup field where Yes/No is taken from another share point list. Can I put a conditional formula to check in the looked up field contains ‘Yes’. I am suggesting ‘contains Yes’ as the looked up field will also have ;# (the row ID). 

Here, I want to hide a field if the value of looked up field != ‘Yes’. Theoretically I got the formula using indexOf. But practically it’s failing.

=if(substring([$intnamefield],indexOf([$intnamefield],'Yes’),3) == 'Yes’, ‘true’, ‘false’)

Here intnamefield is looked up field and this formula goes to field to be hidden.

2 Replies

@ManuelSimon This Yes/No column is main column selected in lookup column settings or extended column (additional shown column)?

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Hi @ManuelSimon 

this works for me:

=if(endsWith([$intnamefield],'#Yes'), 'true', 'false')

Best Regards,