I have encountered an error of which there are already many forum posts about. But i just can't seem to wrap my head around why mine specifically isn't working. I have a Form which when filled out and submitted, should trigger an automation to add to a List. One of the fields in the form is a file upload. This is an optional field, and when the form is being processed it should get the link to the file and put it into the URL field in the list.
Right now, I create a variable:
check if the length is not empty in order to not error out the 'Parse JSON' action, and if not, to set the previous variable to the link (works fine):
and then set the value to the value of the variable if it's not empty, otherwise null
I have tried JUST using the variable, as it should be null if it's empty.
The 'if contract supp' condition statement also passes over the 'Parse JSON' and 'set variable' actions as it is a length of 0. There is no way the value shouldn't be null, but i still receive the following error when i try to set the field in my 'Create item' SharePoint Action.
I'm not sure what to do. I have read many marked correct answers just suggesting using the if(not(empty()),xxx, null) formula, but it doesn't seem to be working for me.
Any pointers in the right direction would be appreciated.
