Declare User Defined Data Types for Powerapps Canvas

(2) Share

Report

Posted on by qwertyuiop

Hi,

I saw in the latest update that powerapps supports custom data types to be used in UDFs. Can you help describe how to declare them

Categories:

Experimental features

I have the same question (0)

All responses (4)

Answers (0)

adithyaselv Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can declare a user-defined time in the Formulas property similar to UDF and then use it in UDF . Please find a simple example below.

-----

//Record type

Point := Type({x: Number, y: Number});

// UDF to compute distance between two points

distance(a:Point,b:Point):Number = Sqrt(Power(b.x - a.x, 2) + Power(b.y-a.y, 2));

//Table type

Points := Type([Point]);

// UDF to check if the given table of points contains a particular point

containsPoint(points: Points, target:Point): Boolean = CountIf(points, ThisRecord.x = target.x && ThisRecord.y = target.y) > 0;

----

notice that you need to use := to declare user-defined type. Type is a special function used to construct a type definition.

Was this reply helpful? Yes No
Suggested answer

adithyaselv Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can declare a user-defined time in the Formulas property similar to UDF and then use it in UDF . Please find a simple example below.

-----

//Record type

Point := Type({x: Number, y: Number});

// UDF to compute distance between two points

distance(a:Point,b:Point):Number = Sqrt(Power(b.x - a.x, 2) + Power(b.y-a.y, 2));

//Table type

Points := Type([Point]);

// UDF to check if the given table of points contains a particular point

containsPoint(points: Points, target:Point): Boolean = CountIf(points, ThisRecord.x = target.x && ThisRecord.y = target.y) > 0;

----

notice that you need to use := to declare user-defined type. Type is a special function used to construct a type definition.

Was this reply helpful? Yes No
IAmIntractable 280 on at

Like (1)

Report
Copy link

Link copied!

I don't believe this is a general release feature yet.

2 people found this reply helpful.

Was this reply helpful? Yes No
laveudelsilenci 9 on at

Like (0)

Report
Copy link

Link copied!

Please, Move this to General. It has not sense Formulas defined functions without defined types.
It is big evolution of PowerApps, to isolate code.
Publish it as preview as soon as possible, it it works perfectly.

1 people found this reply helpful.

Was this reply helpful? Yes No