cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ngreen
Resolver I
Resolver I

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

3 REPLIES 3
fchopo
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:

flow.png

 

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

 

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

Hello,

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

flow.png

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

Hope it helps!

Ferran

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,750)