Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Trying to create a Flow to move data from one SharePoint list to another based on PowerApps data.

Hello, I am trying to use Power Automate to move multiple SharePoint list entries to another sharepoint list entry, if the data in one of the columns matches some text typed into a TextInput in PowerApps. The user inputs text into the TextInput box (For example "Test"), then clicks the Run button and the flow will begin running to go to the first sharepoint list, search through the "Call Reason" column for any entries that have a call reason equal to the text that was inputted (Test). Flow should then grab all of those entries and move them to the new list, while deleting them from the original list. I thought the general structure seemed easy enough to understand, but I can't seem to get this to work. I think it's because of how I have the Get Item step setup, because it forced the ID to be coming from PowerApps, but I'm not getting the ID from there. Any advice?


Flow Help.PNG

Super User
Super User

Hello @ngreen ,

Instead of using get item action, you should use Get Items action and filter the items by the text you are searching. Have a look at this sample:



1) Power Apps button

2) Get the items in a SharePoint list (Tasks) where the column 'Title' contains the word 'Test'. You can use a filter query, using the expression: substringof('test',Title) (be careful que the single quotes around the word you are searching for).

3) For each item found, create another one in the desired list.


Hope it helps!



Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

I completely missed that there is a "Get Item" and "Get Items" in Flow...  I do have a question about the Get Items Filter. Since the "Test" text that is input into powerapps would be something different each time, how do I get flow to recognize that for the Filter? The only dynamic content it is giving me is "Getitem_Id".


You could create a variable (TextToSearch, for example) and click on "Ask in PowerApps":


Then, when you call the flow, you will have to pass its value from PowerApps.

Hope it helps!


Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,679)