Power Platform Community Forum Thread Details

I am new in Power App and Power Flow.
I saw it as a great opportunity to do many things with little need for coding, but I had to change my mind.
Every operation doesn't work as described, either the commands are outdated, or there are limitations. For example, with datacards that don't properly support the 'Users' fields (they only show 100 users and the search doesn't work), and you have to use workarounds.

I wanted to make a simple copy of a SharePoint list, but there isn't an easy way to do it. After exploring the solutions below, I was using Power Flow, but after days and days, I discovered that it doesn't seem possible to copy the content of a 'lookup' column of the 'Multi-value' type.
I tried asking Copilot for help, but it makes me waste days and days of attempts, and even it agrees with me. What you see below is a recap of the attempts made today.

Can you confirm what has been summarized, is it really like that?
Regards

This is the all methods we considered for cloning a SharePoint list and their issues:

1. PnP PowerShell

Goal: Clone list structure and content.

Methods tried:

Connect-PnPOnline -Interactive → Error: Specified method is not supported.

Connect-PnPOnline -UseWebLogin → Deprecated, no longer works.

Connect-PnPOnline -Credentials → Not compatible with MFA.

Connect-PnPOnline -DeviceLogin → Error: WriteObject... Unable to connect.

Problem: Modern authentication + MFA not handled correctly in your environment (likely due to PowerShell ISE or thread restrictions).

Conclusion: Needs PowerShell standard + supported method (DeviceLogin or App Registration). Your environment seems to block even DeviceLogin → likely module or context issue.

2. Power Automate (Flow)

Goal: Copy list from Site A to Site B.

Issues:

No native action to clone structure (only items).

Complex columns (Lookup, Person, Images) → very hard, requires JSON parsing and Send HTTP Request to SharePoint.

Multi-value Person → needs Apply to each and array conversion.

Conclusion: Works for content, not for structure. For structure, you need script or API.

3. SharePoint Migration Tool

Goal: Migrate lists between sites.

Issues:

Designed for migration from file system or SharePoint On-Prem → not ideal for Online-to-Online list cloning.

Poor handling of complex columns (Lookup, Person).