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

(0) Share

Report

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

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
NathanScott 26 on at

Like (0)

Report
@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.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@NathanScott

Please run your flow and share screen of execeuted flow.

Thanks

Hardesh

Was this reply helpful? Yes No
NathanScott 26 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@NathanScott

What is the type of InitializeVariable_value?

Thanks

Hardesh

Was this reply helpful? Yes No
NathanScott 26 on at

Like (1)

Report

@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'.

Was this reply helpful? Yes No
NathanScott 26 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Verified answer

NathanScott 26 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
davidpvaughan 10 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
NathanScott 26 on at

Like (0)

Report

@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! 😎

Was this reply helpful? Yes No