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.

I had a requirement to enable Search on clicking on Enter key on a text box or clicking explicitly on the button to trigger the search. Upon investigation and playing around, I discovered the OnChange trigger works well. So that I don’t duplicate logic across two triggers, I wrapped the logic of the search into a hidden button on the form Referenced the logic into the textbox and icon On Change referencing button from Textbox On Select from Icon

EventMessage Compose Action concat( coalesce(triggerBody()?['subject'], '(No subject)'), ' 📅 ', formatDateTime(triggerBody()?['startWithTimeZone'], 'dd/MM/yyyy HH:mm'), ' - ', formatDateTime(triggerBody()?['endWithTimeZone'], 'dd/MM/yyyy HH:mm'), ' | ', coalesce(triggerBody()?['location'],'Location TBC'), decodeUriComponent('%0A%0A'), coalesce( trim( replace( replace( body('Html_to_text'), ' ', ' ' ), decodeUriComponent('%0A%0A%0A'), decodeUriComponent('%0A%0A') ) ), '' ), decodeUriComponent('%0A'), '🔗 ', if( not(empty(triggerBody()?['webLink'])), concat('[Open](', triggerBody()?['webLink'], ')'), concat( '[Open in Outlook](', 'https://outlook.office.com/calendar/item/', uriComponent(triggerBody()?['id']), ')' ) ), decodeUriComponent('%0A') )