Unanswered

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

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No
pralikab931 18 on at

Like (0)

Report

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

Was this reply helpful? Yes No
pralikab931 18 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No