cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nickduxfield
Level 8

Define the column type in a collection or variable

I have a tempcollection for values used throughout the entire app.

A value of 'contract: wholenumber' is also used.

I was interested when I used this whole number in a simple filter to a live connection where

Filter('Service Code',Contract=First(TempCollection).Contract)

A delegation warning appears.

If I change this to Filter('Service Code',Contract=1)

The delegation warning dissapears.

How can i be certain what the datatype for the column is? Somewhere in my code, the datatype changed when a patch to tempcollection was performed.

 

Note 'contract' is the ID column of a sharepoint list.

2 REPLIES 2
Super User
Super User

Re: Define the column type in a collection or variable

ID columns in SharePoint are numbers. If you have a doubt regarding the value, you can multiply it by 1. That is a shortcut that will convert text to a number. It is the same as wrapping it in Value(text).
nickduxfield
Level 8

Re: Define the column type in a collection or variable

My only method is now to make little collections of this item, or global / context variables. Doing so captures the int32 column correctly.

Thanks guys.

But defining a column data type in a collection that you create yourself for int32 is still unknown to me.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,315)