Using Automate with SharePoint when using an Instant Flow

[caribu]

I need some advice on how to get started here and would really appreciate some pointers. Specifically on how to work with SharePoint using Power Automate when it's an Instant Flow.

I have a SharePoint list upon which I've created a PowerApps Canvas App. I also have an Instant Flow ready called MyFlow that just initialises a variable and does nothing else. I can trigger my Flow by using the below function on a button:

'MyFlow'.Run(Page.LastSubmit.ID)

The Flow is triggered successfully (using a simple Initialize variable action that doesn't really do anything) and from my understanding I have passed the ID of the current item to the Flow, correct?

Method 1: Get Item (singular)

Now in my Flow I want to using the Get Item action (singular) to take values from the current item e.g. I have a field called Status. To configure this Get Item action I expect to configure it by adding my site and list then configuring the Id field to Ask in PowerApps as follows:

However when I save this and trigger the flow from my PowerApps button I get this message:

MyFlow.Run failed: The method 'Run' has an invalid value for parameter 'Getitem_Id'

Method 2: Get Items (multiple)

If I use Get Items I will need to use filtering as there's a limit of 5000 items so filter the query using the Ask in PowerApps as follows:

Again I get the error:

MyFlow.Run failed: The method 'Run' has an invalid value for parameter 'Getitem_Id'

Ultimately I want my flow to be able to get values from the current item. But I'm obviously not passing the ID correctly.

I've spent so much time trying to find an answer and would really appreciate some help, advice or pointers. Many thanks!

[Kcronic1 · Accepted solution]

Hello,

In reviewing your post, it appears that you are trying to get the item of a Power App ID from a SharePoint List, and are receiving an error indicating that you have an invalid value in the Getitem_ID parameter.

The reason for this error is the Getitem_ID in your Power App ID is different than the Getitem_ID in your SharePoint List. 

To be able to achieve getting an item within SharePoint you need to make sure that there is a field in your Power App that references the ID for the SharePoint item in your list.

 Hope this helps! 😊

Regards,

Kristie

Community Support Team

If this post helps, then please click on the "Accept it as the solution" to help the other members find it more quickly.

If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: Get Help + Support - Power Platform | Microsoft Docs