Skip to main content


Copilot Studio - General

PVA Lookup without using Power Automate

Posted on by 155



I am new to PVA and wondering what options are available for validating user input via a lookup to SQL Server without using Power Automate. I want to lookup invoices when the number is provided and return details without having to make a new flow whenever I want to do some sort of validation. I see that sending an HTTP request is available but the db we'd need to reach doesn't have REST endpoints. What other options are available for a quick lookup to return data without going the Power Automate route?

Any help is appreciated!

  • Zap174 Profile Picture
    Zap174 155 on at
    Re: PVA Lookup without using Power Automate

    Hello @HenryJammes ,thanks for the response.


    It's not that we can't use Power Automate but we just wanted to see what options are available besides it as we wanted to avoid creating one flow every time we want to lookup a different value in an external table. So Power Automate is a viable option, we just wanted to explore what alternatives there were.


    Thanks for the resources! We'll look into them!

  • HenryJammes Profile Picture
    HenryJammes on at
    Re: PVA Lookup without using Power Automate

    I'm curious, why can't you use Power Automate?


    Without Power Automate and without HTTP requests, you're seriously limiting your options but you may try a last, pro-dev, option: call a Bot Framework skill from PVA: Use Microsoft Bot Framework skills - Power Virtual Agents | Microsoft Learn


    That said, with plugin actions, more connectors will become available within PVA and without having to go through Power Automate.

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…


WarrenBelz Profile Picture

WarrenBelz 137,998

RandyHayes Profile Picture

RandyHayes 76,308

Pstork1 Profile Picture

Pstork1 63,059