Hi,
I am trying to create a flow that will update a sharepoint list based on Microsoft Form submission.
I need a means of updating the sharepoint list without overwriting other sharepoint list fields if the corresponding form fields are empty.
This form might be completed several times, so for example:
Sharepoint list columns
Name:
Team:
Colour:
Form fields
Name:
Team:
Colour:
Sharon might fill in the form with:
Name: Sharon
Team: Central
Colour: Red
So the sharepoint list item is created with:
Name: Sharon
Team: Central
Colour: Red
Sharon might fill in the form a second time:
Name: Sharon
Team: East
Colour:
And the flow triggers the sharepoint list to update to:
Name: Sharon
Team: Central
Colour:
When what I want is for it to retain the original colour of Red from the first submission.
Is there a way to "skip" if empty or If empty return null?
