Using Dataverse Content to update row in Excel Sheet

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

I am using two Dataverse tables to update information on an Excel document. When I try to update the "Traveler Name" I get this error: "The request entity's media type 'text/plain' is not supported for this resource."

I am not sure what it is referring to, this flow worked fine when I was testing on the template, but now that it is in the copy it will not work.

I have verified that my table names stayed the same in the copy.

Thanks

Here is my Flow:

TR Flow 1-27.png

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @gfeldhake ,

Please review the following as it looks like they had the same issue and might have some good approaches to solve with the compose etc. https://powerusers.microsoft.com/t5/General-Power-Automate/Add-row-to-excel-Business/td-p/759444

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

Hi @dpoggemann

Thank you for sending this. I created a compose as it suggests but am getting the same "The request entity's media type 'text/plain' is not supported for this resource." error.

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like (0)

Report
Copy link

Link copied!
@gfeldhake, try using the array in the Provide Item Properties:

{ "ColumnName1": "Value", "ColumnName2": "Value" }

Was this reply helpful? Yes No
Verified answer

GF-02121351-0 239 on at

Like (0)

Report
Copy link

Link copied!

I ended up having to use the office 365 connector to grab the user profile.

Was this reply helpful? Yes No