Power Platform Community Forum Thread Details

Hello everyone,

I am trying to create a scheduled flow that will basically transfer the SharePoint List into a new excel file for archive purposes.
I have found this solution as others that I found available were returning errors in different stages.

Unfortunately, when I am running the Flow it returns this error:

Error Details:

"A value must be provided for item. clientRequestId: 3253c46c-a0a9-41b1-af86-a8ae0752b92b"

Outputs:

{

"status": 400,

"message": "A value must be provided for item.\r\nclientRequestId: 3253c46c-a0a9-41b1-af86-a8ae0752b92b",

"error": {

"message": "A value must be provided for item."

"source": "excelonline-ne.azconn-ne-003.p.azurewebsites.net"

}

I believe it is because I am using a multi choice column and I need to format the array before importing the values within the excel file but I am not sure, any suggestions?

In the last step that I need to map the columns of the excel file to those in the SharePoint List I am just placing the name fields from SharePoint as those return in the dynamic context (not the "value" field).

Any suggestions please? Even if it is an entirely different solution, I just need to make that work

Categories:

Using flows

managed to resolve the issue.
Following exactly the above steps with one additional change within the apply to each stage.

Before create the "add row into a table" you will need for each column that using multi select choice to create two additional steps:

Select: in which you place in the "From" section the field from SharePoint List and change the map to text and type in the expression field: item()?['value']

One more step, add a Join from operations selections

Within the From section place the "Output" from the previous step and in the "Join With" place your delimiter which in my case is a comma.

At last, when you adding the rows in the table, for those columns that contain multi-select you need to place the output from the join

I hope that help others as well having the same issue