Flow.RUN() failed error "TriggerInputSchemaMismatch". Error type : "Expected Number but got String"

[pralikab931]

Hi,

I am trying to run a flow (Execute SQL Stored Procedure) where the flow takes a GroupID from varRecord (Gallery.Selected) and an Individual ID from ComboBox.Selected.ID.

I am not able to fetch the GroupID using varRecord.GroupID. It comes up as blank. When I do a LookUp with the table where the GroupID is stored, it gives me a schema mismatch error. It says expected number but got string.

I tried using Value(LookUp(...)), but that didn't help either.

I am running the SP on the 'OnSelect' property of the ComboBox. The error pops up on PowerApps even before the Flow can run.

[Pstork1]

I suspect that the GroupId property of varRecord is being read as a string when you need an integer.  Try replacing your use of varRecord.GroupId in the Lookup with value(varRecord.GroupId), rather than putting the Value() outside the lookup.

[Jeff_Thorpe]

Is the error coming from the Lookup(), if so, maybe it has to with the condition in the lookup. What is the lookup formula?

[pralikab931]

Now I get an error as follows:

'Execute Procedure V2' requires the property 'parameter/id' to be a string of maximum length '-1' but is of length '1'. error in powerapps

[pralikab931]

LookUp(IMTable, IM_No = Gallery.Selected.IM_No).GroupID

IMTable has GroupID against every IM_No

Data type of IM_No and GroupID is int.

[Jeff_Thorpe]

Can you try this and see if the lookup will return a value instead of an error.

LookUp(IMTable, IM_No = Value(Gallery.Selected.IM_No)).GroupID