Trigger a flow to create multiple records based on the id and columns of a record

(1) Share

Report

Posted on by CU07041942-0

I've a website which has only entra external users enabled, my requirement is to send the 'id', 'columns'(comma separated) and 'number of records to be created' of a particular record to a Power Automate flow which will run and create records along with the columns. This is achievable by using portal WEB API, but I'm unable to figure out how can I use the Power Automate flow to do so, I tried using the http request action but got access denied error (whereas I'm able to access the uri when hit from the browser).

Categories:

WEB API

All responses (2)

Answers (0)

Suggested answer

Fubar 7,964 Super User 2025 Season 1 on at

Like (0)

Report
Trigger a flow to create multiple records based on the id and columns of a record

There are different ways to use Flow and you may need to choose the correct method for your scenario.

Using Flow in the traditional sense would be on record update/create using a Dataverse trigger

There is a special type of Flow called a Power Pages Flow, this flow can be called from power pages using an ajax call (similar to the Portals Web API) this flow has some additional security built into it. https://learn.microsoft.com/en-us/power-pages/configure/cloud-flow-integration

https://learn.microsoft.com/en-us/power-pages/configure/power-automate-how-to

You should also be able to call a standard Flow that is a HTTP Request trigger, however if using with a power pages site use a Power Pages Flow instead (as it already has additional security built into it). If you are attempting to call a HTTP request flow and you are getting an error it may be something you have in your code or the flow configuration or additional security implemented in your organisation (e.g. azure api management) - as you mentioned that it ran from the browser the first area to look would be are you using the correct method in your code/flow (your browser url bar will be a GET request but your code may be a POST request, and the flow trigger node may be configured to only accept GET requests).
Michael E. Gernaey 43,413 Super User 2025 Season 1 on at

Like (0)

Report

Trigger a flow to create multiple records based on the id and columns of a record

Hi @CU07041942-0

Some context is missing. Where is this website hosted? If its outside of Azure / Power Platform etc then you will need to post the information to an HTTP End Point, technically there are other ways, like have your Web Site pushdata to sharepoint and a flow triggers and does the work etc,

Also, you say you want to push IDs and how many records to create. So are you just creating like blank records in a list? What are the IDs? since those are sharepoint created, is the ID to identify a row, but you said create not update.

The other issue is licensing, people who are triggering flows need to have licenses, not just a service account or single license that everyone uses to trigger it.

little confused (maybe just me) what you need and exactly how it would look like.

can you share the flow you created. You said you are getting Permissions Denied. Again these have to be licenses people to call the flows HTTP endpoint and of course authenticated etc. So it would help to understand what exactly gave the error.

Community site session details

Trigger a flow to create multiple records based on the id and columns of a record

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Pages

Featured topics

Product updates

Community site session details

Trigger a flow to create multiple records based on the id and columns of a record

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Pages

Featured topics

Product updates