Missing Dynamic content when copying Items from one Sharepoint List to another

[mobilismexico]

Hi,

I need to migrate one List from Site A to another List in Site B. Columns are named the same and are of the same Type, except for the Title column, which is the reason I need to migrate the List. In site A my Title column is of Type Lookup. Whenever I export this List to Excel, the Lookup column shows [List] in every row instead of the actual value. So, my flow is meant to move all Items to a new List where the Title is a straightforward Text Type.

I cannot find dynamic values of List A. No Apply To Each block is generated automatically. I'm stuck in the steps shown below:

No Columns shown in Dynamic content

[v-jefferni]

Hi @mobilismexico ,

You can manually add the apply to each control, select value the dynamic content in From parameter. After that, add the create item action in the loop then check if you can find the columns in dynamic contents.

Actually when I made a test of your scenario, the columns from get item action showed up normally. I am wondering if get items from list A from your end worked as expected. Please remove the create item action and run the flow, check the outputs from the Get items action.

Besides, please make sure you have right permissions to connect to list A.

Best regars,

[mobilismexico]

hi @v-jefferni ,

I followed your suggestions but it did not help, the dynamic content is still missing. The only difference is that now I can see a "Current item" field in the Dynamic content window, as seen below:

[mobilismexico]

Hi again, @v-jefferni ,

The Get Items action did not even save!

The field with problem ("Proveedor") is precisely the reason why I need to migrate to a new List. "Proveedor" is of type Lookup.

Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'sharepointonline' operation 'GetTable' failed with status code 'BadRequest'. This may indicate invalid input parameters. Error response: { "status": 400, "message": "The required field \"Proveedor\" data type is not supported\r\nclientRequestId: b39b9d68-f2f8-4f9b-b831-4405dfaa3237\r\nserviceRequestId: b39b9d68-f2f8-4f9b-b831-4405dfaa3237" }'.

[v-jefferni]

Hi @mobilismexico ,

Based on some other threads as below:

Solved: Error - data type not supported - Power Platform Community (microsoft.com)

Please check and see if the Proveedor LookUp column has been set to required in your list. Uncheck the required option of this column, remove and re-add the Get items action then try and save the flow again.

Best regards,