Forum Discussion

childishbambino's avatar
childishbambino
Copper Contributor
May 31, 2023

how to use powershells sharepoint PnP module change columns conditional formulas?

In sharepoinm, I have a custom formula for a column , called column A, that looks like  this:   =if[$myColumnB],'true','false') I need to do this 200 times, with different columns, how do I use ...
powershell
SharePoint Online
dperez13's avatar
dperez13
Copper Contributor
Jun 01, 2023

thank you, I missed that place. I am now able to connect to my spo and make the changes, but now my changes arent working as I believe I have messed up with the logic, tell me , is this okay:

$conditionalFormula = "=if([{0}] = true && [{1}] = true, 'true', 'false')" -f '$myColumnB', '$myColumnC'

BOTH B AND C ARE CHECKBOXES. why isnt this working?

but this doesnt work for me.
my column A or -Identity is " -Identity "MY_X0020_NAME"

ganeshsanap's avatar
ganeshsanap
MVP
Jun 02, 2023

dperez13 Check this article for string formatting in PowerShell: Understanding PowerShell and Basic String Formatting 

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.

Resources