Get Items failing when filter value return null

(0) Share

Report

Posted on by cammc

I have built an app that sends information to sharepoint - the automation then picks up the data, and populates some templates and emails it back to the user. So far so good. 3 document will always be returned (and are currently on parallel branches) and work fine.

However when trying to build out one of the two that may or may not be returned the get items block fails. I currently have this filtered to where the GUID is present on the master sheet that triggers the flow, and also on the sheet which contains the data for that branch then get items. The issue I am having is that get items fails if it cannot locate a match, and for this document there may not be a match? any help on how I can wrap this so I can check that the GUID is present and then if it is, trigger the get items. (which at this moment im not sure how to do, because you would need to get the items to check it in the first place?)

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

cammc 40 on at

Like (0)

Report

Re: Get Items failing when filter value return null

and I an idiot and missed the basic one. It wasn't failing because of it retuning null but because I forgot to wrap the GUID with ''

Was this reply helpful? Yes No