Unanswered

Nullable integer PowerApps form field

(0) Share

Report

Posted on by Atul22

I am new to PowerApps and using a flow. PowerApps form field of datatype is int (number). This field is blank and passing it to a PowerApps flow, to check blank integer I am using empty() function in a flow. but it errored out as below

[Unable to process template language expressions in action 'Execute_stored_procedure_(V2)' inputs at line '1' and column '9620': 'The template language function 'empty' expects its parameter to be an object, an array or a string. The provided value is of type 'Integer'. Please see https://aka.ms/logicexpressions#empty for usage details.'.]

Please assist me a correct property to check blank integer / blank float values in a flow.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Atul22 the empty parameter expects the type of value to be object, array or string, so what you can do is cast the value to string like @empty(string(triggerBody()?['parameter']))

Was this reply helpful? Yes No
Atul22 4 on at

Like (0)

Report
Copy link

Link copied!

Tried as
if(empty(string(triggerBody()['Executestoredprocedure(V2)_AMOUNT'])),null,triggerBody()['Executestoredprocedure(V2)_AMOUNT'])
But still not able to run the flow, this time flow run history did not had error entry but powerapps screen button showed error (The method 'Run' has an invalid value for parameter 'Executestoredprocedure(V2)_AMOUNT'

Please assist.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Atul22 can you share screenshot of your flow, i want to see where and how you are using this expression

Was this reply helpful? Yes No