Hey, you can use a single "Get items" action to retrieve all the items from SharePoint list, then use "Apply to each" action to loop through the items and check their values.
Get items from SharePoint List:
Use the "Get items" action to retrieve all items from your SharePoint list.
Initialize a variable (Array):
Use the "Initialize variable" to create an array that will hold the items that need to be updated.
Apply to each item:
Use the "Apply to each" to loop through the items retrieved from the "Get items" action.
Inside the loop, use a condition to check if the value of the column is "Published."
If the condition is true, append the item to the array variable.
Update items in SharePoint List:
After the loop, use another "Apply to each" action to loop through the array variable.
Inside this loop, use the "Update item" action to update the value of the column to "Not Priced."
Please try with the Above solution hope it will work.
I am Preparing the flow. I will share the flow once it is done.
-----------------------------------------------------------------------------------------------------------------------------------------------------
If my suggestion helps you, please gives it a Like and Marks as a Solution. Which motivates to solve more problems.
Thanks,
Sayan Patra
RPA Developer
