0

I have a Hyperlink or Picture column in sharepoint online list named "Document Link" I am creating a flow where I need to check a condition if this column is empty or null. I have tried few things but while using Get Items action the action is not giving result DocumentLink=null if it is empty. It is gives the values if it is not null and hence I am not able to check the empty condition against it.

0

use HTTP request to SharePoint and use API GET. Documentation here, it will give you NULL values. Include column in Select property, like here.

Like this: enter image description here

it will return JSON collection with null values too (see in next picture) of Items (or if you use item(id) in HTTP request URI > return only 1 item)

enter image description here

after this you just need Parse JSON action and after this work with the properties from it.

Hope it helps!

We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.