Adding REST API to declarative agent, e.g. MS Learn articles Key Advantages of Each: Aspect WebSearch REST API Content Scope Entire indexed web content Specific database/service Query Flexibility Natural language Structured parameters Data Freshness Based on search index Real-time from source Result Format Search results + snippets Structured data objects User Experience More conversational More precise/filtered Performance Depends on search complexity Typically faster for specific queries

Using negative <> can trigger the delegation warning Filter(list,‘Title’ <> “No”) Using = instead makes the delegation warning goes away Filter(list,‘Title’ = “No”)

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.