Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Using Dataverse Content to update row in Excel Sheet

(0) ShareShare
ReportReport
Posted on by 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:
  • Verified answer
    GF-02121351-0 Profile Picture
    GF-02121351-0 239 on at
    Re: Using Dataverse Content to update row in Excel Sheet

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

  • AhmedSalih Profile Picture
    AhmedSalih 6,678 on at
    Re: Using Dataverse Content to update row in Excel Sheet

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

     

    {
    "ColumnName1": "Value",
    "ColumnName2": "Value"
    }
  • GF-02121351-0 Profile Picture
    GF-02121351-0 239 on at
    Re: Using Dataverse Content to update row in Excel Sheet

    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. 

     

    Screenshot 2023-01-30 073802.png

    Screenshot 2023-01-30 073945.png

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,273 on at
    Re: Using Dataverse Content to update row in Excel Sheet

    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Kickstarter Events…

Register for Microsoft Kickstarter Events…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #13 Writing Effective Answers…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,858

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,505

Leaderboard

Featured topics