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

[ngreen]

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?

[fchopo]

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!

Ferran

[ngreen]

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

[fchopo]

Hello,

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!

Ferran