Hi,
I'm a new Power Apps user and I've been playing around with custom connectors. I've been able to create a connector with multiple GET methods to retrieve data from an on-premise application, and I've set up a connection instance. Now I want to be able to store the data retrieved from those GET methods in a database Entity. Using "Get Data" (Power Query) I can't see how to use my custom connector connection as a data source. Surely that's a fairly logical use for the custom connector? There's a "Web API" source, but I have to configure it again manually, and it only allows me to configure a single GET call for each instance. Am I missing something here?
Thanks,
Greg
Hello @packnology
Once you have your custom connector, you can use it inside a flow.
Once you are using the custom connector in a flow, you can select which data source you want to use the save the data,
Hope this article can help you:
https://docs.microsoft.com/en-us/connectors/custom-connectors/use-custom-connector-flow
Hi!
I've the same problem with a Web API I would like to use to import some Big Data into my Common Data Service using "dataflow" together with Power Query as ETL-Tool. So its clear for me how to use my custom REST API connector with Power Automate, but how can I use it with dataflow?
If there's no way to use the custom connector with Dataflow and Power-Query, how could I import "Big Data" with over 10.000 records into CDS without an Power Automate "Apply to each" step? Is there a way to import the json response directly without checking each row (Power Automate CDS connector offers just "Create a new record in entity")...
Hopefully you can understand my issue.
Cheers,
Sven
Hi,
Have you had any luck using a custom connector in a dataflow.
Thanks
E
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
22 | |
5 | |
4 | |
3 | |
3 |
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
5 |