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

(0) Share

Report

Posted on by mobilismexico

261

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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

v-jefferni on at

Like (0)

Report

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

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,

Was this reply helpful? Yes No
mobilismexico 261 on at

Like (0)

Report

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

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:

Was this reply helpful? Yes No
mobilismexico 261 on at

Like (0)

Report

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

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" }'.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

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

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,

Was this reply helpful? Yes No