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.


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!

| improve this answer | |
  • Hi Zdeněk Vinduška . It worked . Thanks:) – Liza Daiya Mar 11 '19 at 10:10
  • you're welcome :) – Zdeněk Vinduška Mar 12 '19 at 7:10

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.