jsom set datetime to null

use null ;)

sharepoint worklow history

to see how long the process took add modified to the view

vba doesnt short circuit

here

"in" in access

in ssql server this

select * from

(select 1 as p union select 2 as p union select 3 as p ) as main

where p in (1,1)

will give you  1 row

in access - you will get 2 rows

sharepoint lookup threshold hit in access

set no caching in current database settings

how to get more than 100 items in a rest call in SP workflow

pathetically, sharepoint workflow bombed when i tried to get the __next parameter

with

System.ApplicationException: HTTP 500  {"Transfer-Encoding":["chunked"],"X-SharePointHealthScore



so i changed the call to say gt ID - initially ID= 0 and when i looped through the first 100 i set the ID to the new id's - then I ran the call again - gt ID so it got the next group

ACCESS vba not running

make sure content enabled