The input body for trigger 'manual' of type 'Request' did not match its schema definition.

[NathanScott]

Hi all, 

First time posting here - hoping somebody can help!

I'm creating an Instant flow triggered from PowerApps. The purpose of this flow is to grab ONE item from a SharePoint list based on an ID which the Power App would pass when running the flow.

For some reason, whenever I add the 'Get Item' action in Flow, I get the following 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.'.

If I remove the 'Get Item' action, it runs just fine. Here's my entire flow, for reference. You can see I've tried converting the value to an integer with no joy. In addition, I've tried not even using this value in the Get Items call (just setting the ID value to '3'), and it still doesn't work. Very confused and would appreciate any help!

It's worth noting:

For some odd reason, this doesn't present any issue when using the 'Get Items' action and passing '$filter= ID eq <param from Power Apps>' , or when using an HTTP request with the same. I just don't know how to send either of those methods back to PowerApps in a way that would get me what I need (people picker.email property to compare current user email against.) 

[Hardesh15]

@NathanScott 

ID is a number column in SharePoint and you are supply string which is causing type mismatch. please use int(3) in expression for get item.

Thanks

Hardesh

[NathanScott]

@Hardesh15  -- unfortunately that doesn't resolve the issue. I have tried the following:

• SelectedItemID (variable I set in the preceding step.)
• Int(3)
• 3
• int(triggerBody()['Initializevariable_Value'])

All 3 options return the same error when I test the flow.

[Hardesh15]

@NathanScott 

Please run your flow and share screen of execeuted  flow.

Thanks

Hardesh

[NathanScott]

@Hardesh15 

When I click 'Fix the Trigger', this is what I'm able to see:

[Hardesh15]

@NathanScott 

What is the type of InitializeVariable_value?

Thanks

Hardesh

[NathanScott]

@Hardesh15 I'm not an expert but based on my most recent screenshot it looks like the type is integer. "InitializeVariable_value" was created when I clicked the 'Ask in PowerApps' button in the context of setting the 'SelectedItemID' integer variable. I didn't get an option to select the 'type' (I don't think I ever have when I'm doing an 'Ask in PowerApps'.

[NathanScott]

@Hardesh15 Been trying to debug for several hours now 😫

This flow runs fine:

As soon as I add a 'Ask in Powerapps', even if I don't use that variable, the flow fails to start with the same error when I supply any number:

IF I remove the 'Get Items' action, leaving only the Init variable action, unless I wrap the InitializeVariable_Value in an int() expression, I get the following error:

After wrapping the 'Initializevariable_Value' in an int() function like so:

..the flow runs fine again (without the 'Get Item', so it's really just firing and setting an integer variable.)

The moment I add a 'Get Item' action back, and pass that variable (which IS AN INTEGER) as the 'ID' param:

We receive the same error message on type mismatch:

Very, very confused.

[NathanScott · Accepted solution]

OK... I found a workaround. Silly, but here it is:

It seems powerapps could only return me an input as a string, and flow got angry any time I tried to reference that input as an integer, or even as an input to a variable that would be used as an integer.

Now, I'm doing the 'Ask in PowerApps' within my 'Init StringIDVar' (type String.), then I initiate an integer variable 'InitIDVar' and set it's value to StringIDVar. 

I use 'InitIDVar' in my 'Get Item' ID Param, and it works beautifully.

[davidpvaughan]

Hi, I'm experiencing the same issue when trying to use a PowerApps trigger to get a SharePoint item

I tried the solution posted above but still encounter issues. 

Please see attached screenshot, it doesn't seem to handle the transition from string to integer. 

We have other solutions currently in use that perform the same action (PowerApp trigger to get SharePoint item) which are still working without issue? 

[NathanScott]

@davidpvaughan 

I should have clarified in my original solution post -- I'm wrapping the string variable in an int() expression as follows:

I just reproduced this solution on another flow I was working on this morning, so I hope this helps! 😎

[davidpvaughan]

That's done the trick 🙂 thank you

[Ryn]

Hi, Could you edit your original solution and add that you wrap your string in int() please?

I wonder if the int64 type used by PowerApps trigger is different to the integer type used by `Get Item` SP Action.

[jsondotexe]

Hi @NathanScott ,

May you help me with this? I have the same issue but the data type I am using is String. Here's the screenshot error:

[DickM]

I am having this error on the simplest of Exports (one field of string values from a table) in Power BI's Power Automate.

It is a VERY simple automation.

Thoughts.

**bleep** Moffat