The Stack Overflow podcast is back! Listen to an interview with our new CEO.

New answers tagged

0

I tested with two choice fields with same field name without other condition and it works as expected: Suggest to test with Caml Designer to build the correct result: Caml Designer Download


1

Date and time in sharepoint is ISO 8601 format. You could try the below script: $spweb = get-spweb http://sp/sites/test/ $splist = $spweb.Lists.TryGetList("TestList") $query = New-Object Microsoft.SharePoint.SPQuery $query.Query = " <Where> <And> <Geq> <FieldRef Name='Created' /> <...


1

Try using something like below: <Query> <Where> <And> <Geq> <FieldRef Name="Created" /> <Value IncludeTimeValue="FALSE" Type="DateTime">2019-09-01</Value> </Geq> <Leq> <FieldRef Name="Created" /> <Value IncludeTimeValue="FALSE" Type="...


1

You're not able to combine those queries into a single CAML-query but you can query all those items in the same request, ex: List tasksList = context.Web.Lists.GetByTitle("Tasks"); List meetingList = context.Web.Lists.GetByTitle("Meeting"); List newsList = context.Web.Lists.GetByTitle("News"); CamlQuery tasksQuery = new CamlQuery() { ViewXml = '...' }; ...


3

This is not a special character issue. You cannot combine Contains element with Choice field type. Try Eq element instead: <ViewFields> <FieldRef Name='ActionStatus' /> </ViewFields> <Where> <Eq> <FieldRef Name='Region' /> <Value Type='Choice'>East & West</Value> </Eq> </Where>


0

As per this blog, it's stating that you wrap your special text in <![CDATA[ TEXT ]]>. So in your situation it would be <![CDATA[East & West]]>. For others that are building CAML queries programically, you can split the string and add your variable as normal. const direction = "East & West"; const camlString = '<Value Type="Choice"&...


0

If you want to set a field's value on form submit, you can add a button and set rules on the button as the following:


Top 50 recent answers are included