Here’s a step-by-step guide to implement your Power Automate flow:

1.Trigger:

Add a PowerApps trigger (manual) to start the flow and accept two inputs: SearchInput (text) and Database (text_1). 2.Get Items from SharePoint:

Add a “Get items” action for SharePoint. Set the site address and list/table. Use a filter: substringof(’@{triggerBody()[’text’]}’,Title) and Database eq ‘@{triggerBody()[’text_1’]}’ and InsiderList eq ‘No’ 3.Select Action:

Add a “Select” data operation. From: @outputs(‘Get_items’)?[‘body/value’] Map fields: ID, Title, Team, Channel, Folder Status, Database, Path. 4.Compose Action:

Add a “Compose” action. Inputs: @body(‘Select’) 5.Respond to PowerApps:

Add a “Respond to a Power App or flow” action. Output: @{outputs(‘Compose’)} 6.Connect the actions:

Ensure each action runs after the previous one succeeds, as shown in your flow. This flow will search SharePoint based on user input and return filtered results to PowerApps.