http request assistance

(0) Share

Report

Posted on by Tango

1,164

Turns out using Sharepoint Get will not work for my use case as I am searching for a column that contains some null results. Instead http post is the answer

I have it working with

_api/web/lists/getbytitle('MyList')/Items?$filter=AssignedTo%20eq%20null

but I would like to add a second filter on the Created column (date column) in Sharepoint list

Created lt 'addDays(convertFromUtc(utcNow(),'AUS Eastern Standard Time'),2,'yyyy-MM-dd')'

but the following is throwing a Expression is not valid error

_api/web/lists/getbytitle('MyList')/Items?$filter=AssignedTo%20eq%20null%20and%20CreatedDate%20gt%20%27addDays(convertFromUtc(utcNow(),%27AUS%20Eastern%20Standard%20Time%27),2,%27yyyy-MM-dd%27)%27

Thanks in advance for any assistance

Todd

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (1)

Report
Hi @Tango,

It looks like you have added the expression as plain text.

Can you try this instead and see if that makes a difference?

_api/web/lists/getbytitle('MyList')/Items?$filter=AssignedTo eq null and Created lt '@{addDays(convertFromUtc(utcNow(),'AUS Eastern Standard Time'),2,'yyyy-MM-dd')}'

Was this reply helpful? Yes No
Tango 1,164 on at

Like (0)

Report

Thanks so much @Expiscornovus Much appreciated

Was this reply helpful? Yes No