Is there a way through using a piece of code to update all the specific values of a column of SharePoint online to something else?
I am looking for an equivalent of the below SQL code for Sharepoint online
udate list1 set att1='Region2' where att1 contains 'RegionB' and att2='True' --Corected based on the feedback
Do we need to have a different piece of code for choice/multichoice column?
Does the code need to iterate through every single record if it is a multichoice option? I guess it only needs to replace one of the selected options which is the one that we are interested and should leave the rest intact?
If there is a way, I assume before doing this operation we need to turn all the flows of this list which are triggered by update/insert off, If this correct, Is there a way to avoid or shut down these flows through code or turning them off should be done manually?