I have this column in a sharepoint file library called "Department_List". This has a bunch of values that look like this separated by a comma.
["1.1.1 New Department"],["2.2.2 New 2 Department"], ["3.3.3 New 3 Department"],etc.
What happens is the flow is kicked off from a Delete Department in Powerapps. That then runs and removes the department from a separate Department SharePoint List but I also need it to go into the Document Library, see if that Department Title is in that 'department_list' column, remove it while leaving the other values there.
Click trash icon in Powerapps for department 2.2.2 New 2 Department, workflow kicks off, it goes into my other Department SharePoint List, deletes it from there, then need to hop over to the 'smc doc library' search for that same 'title' in the "department_list" column and remove it but still keep the other values.
I hope that explained it. 🙂
