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.

Within Power Apps, run the flow

/ClearCollect( colFolderMapping, ForAll( Table( ParseJSON( SearchList.Run( txtFolderValue.Text, drpDatabase.Selected.Value ).output ) ), { ID: Value(Value.ID), ‘Title’: Value.‘Title’, ‘Path’: Value.‘Path’, ‘Team’: Value.‘Team’, ‘Channel’: Value.‘Channel’, ‘Folder Status’: Value.‘Folder Status’ } ) );/