Power Platform Community Forum Thread Details

Hi everyone,

I am trying to update my SharePoint lists with a scheduled flow.

I know there is a workaround to give a value to an empty cell in Share Point lists with a if function (ex: if(empty(item()['Title']), null, empty(item()['Title']))).

However, I can't find a way to tell the flow: "if I have nothing to update then keep the cell empty (e.g. null)".

Here below part of the flow (see image):

- left: delete single item after a "filter array is equal to false" (it works)

- right: update single item (I thought following the same steps but with "filter array is equal to true") --> it does not work because I have to consider 4 situations and one of them seems to give extra challenges:

1- if value to update is null and cell is null (seems to give problem)

2- if value to update is null and cell is value (ok)

3- if value to update is value and cell is null (workaround with a if function)

4- if value to update value and cell is value (ok)