Power Automate triggers with whole numbers

[akaskela]

Not sure if this is a bug from the provider or Power Automate.

When I set up a "When a record is selected" on my virtual entity, and reference the properties lower in my flow, all field types seem to work except for int fields. When I use an integer field (assigning it from the selected entity to a int variable even), I get an error that the trigger is broken (from flow) and an error trying to invoke it in CDS. I've successfully used text, yes/no, dates and PK fields.

This is the error message I get when invoking it in CDS: Error: The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Invalid type. Expected Integer but got String.,Invalid type. Expected Integer but got String.'.

The field is configured as Whole Number in CDS, and int in the database.

[mikefactorial]

Probably a bug. I'm not handling type conversions very well in the current iteration. Adding it to my list when I revisit some of the bugs / features I've been meaning to address in the next couple weeks.

[akaskela]

I found a workaround:

• Do a get record to retrieve the record that is on the trigger
• The int field works like a string, so when you need to use it somewhere you can just wrap the property in an int() expression to cast it appropriately.