Power Platform Community Forum Thread Details

Copy Data from a List to another

This method runs directly in the browser using JavaScript.

Enable Web API :Make sure your tables are available to use with the Web API in Power Pages
Set Up Table Permissions and Web Roles
- Give users the right permissions (Read/Write) on TABLEA and TABLEB.
- Assign these permissions to the correct web roles (like Authenticated Users)
Add a Button to the Basic Form : Insert a custom button (e.g., “Copy Data”) on your page or form.
Write JavaScript Using Web API:
- Fetch records from TABLEA
- Find matching records in TABLEB (where titles match)
- Update field1 and field2 in TABLEB with values from TABLE

2) Server-Side Approach (Using Power Automate Flow)

Add a Custom Button to Your Basic Form: Add a button like “Copy Data”
Write JavaScript to Trigger a Flow: When the button is clicked, send a request to your flow (HTTP trigger).
Create the Power Automate Flow

Action 1: List all rows from TABLEA

Loop: For each record in TABLEA:
- Check if a record with the same title exists in TABLEB
- If a match is found: Update the field1 and field2 in TABLEB using values from TABLEA