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?
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
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
Helpful resources
2021 Release Wave 2 Plan
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
