Power Platform Community Forum Thread Details

Hello, thank you in advance for any assistance in advance.

I am attempting to implement a couple of YouTube videos to wipe a SharePoint list of data then re-upload a cleaned set of data from an Excel file in my OneDrive. I was able to get the first part working fairly easily which was clearing the SharePoint list. I have not been able to get the 2nd part working however.

For reference the method I am using is in the following:

https://www.youtube.com/watch?v=2dV7fI4GUYU

The sticking point appears to be posting the multiselect choice fields to the SharePoint list. If I remove those fields the flow works, but from appearances skips the multiselect fields with values in them.

I will probably be more thorough than I need to be in explaining, but I don't want to miss anything.

Screenshot of the empty list (red marks are the fields giving post issues and are the only multiselect choice columns):

Screenshot of the step that generates the data:

The expression in each field is the following, and is only changed to represent the field named:

if(empty(item()?['CDBPKey']), null, item()?['CDBPKey'])

The if statement is being used otherwise it skips fields within the Excel that have no data. From my understanding if there is no data this sets the value to null and still writes the row.

Where the issue is when I test the flow is the post on the ApprovalMatrix and ScopeMatrix multiselect.

if(empty(item()?['ApprovalMatrix']), null, item()?['ApprovalMatrix'])

if(empty(item()?['ScopeMatrix']), null, item()?['ScopeMatrix'])

When I run the flow, the duration is approximately 13 seconds and I get the following at the SendBatch step:

The inputs are the following, so I know that it is getting the data properly (split it out by line for ease of reading:

The output is base64 but translated I get the following 2 errors (I get the primitive value error once and the null value error for each line it seems) :

I have spend several hours trying to work through this and pretty sure it is narrowed down to posting the data to the multi-select choice field which is essentially the final step other than reporting it is complete.

Any advice or assistance is very much appreciated. If I need to provide more information I can do that as well.

Categories:

Building flows