Error: Adding rows to Excel table from Dataverse

[kstudsrud1]

Hello! I am currently trying to add rows from dataverse into an excel spreadsheet.

I am utilizing a excel template, copying it, creating a new one, creating a table within the file, and adding the rows. The error I am getting is noted on right hand "Entity's media type 'text/plan' is not support for this resource."

Any help on this error or work arounds would be appreciated!

Error

Setup

[ManishSolanki]

Hi @kstudsrud1 

You need to modify the expression used inside "Apply to each" action for creating array.

Here is the sample flow, I have collected data in 'Create CSV table' action and the subsequent actions are mentioned below:

1. Add the below expression inside "Apply to each" action to create an array from the output of CSV table. The idea is to split each line by new line character and skip the first element which contains the header row:

Expression used in the above screenshot: 

skip(split(body('Create_CSV_table'),decodeUriComponent('%0A')),1)

2. Next, we will split each iterated item with comma (,) to get the column values of each row in an array:

Expression used inside compose action:

split(item(),',')

3. Finally, using index get the value of each column from the array generated by compose action:

Expression used for getting value of column 1 (Deliverable):

outputs('Compose_2')[0]

Similarly, you can get the value of other columns by specifying the index.

In your case since you are adding row to a dynamically created excel file so you can use an object variable with the below JSON and pass the object to "Row" input parameter:

{
"Deliverable":@{outputs('Compose_2')[0]},
"Category":@{outputs('Compose_2')[1]},
"Frequency":@{outputs('Compose_2')[2]},
"StartDate":@{outputs('Compose_2')[3]},
"DueDate":@{outputs('Compose_2')[4]}
}

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks