Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Custom Value in "Add a Row into a Table"

Posted on 28 Nov 2024 17:20:27 by

Hello dear forum,

I have a problem with MS PowerAutomate. An order form triggers a flow. In this form, price and department are specified. An order is thus assigned to a department. The information from the order form is collected in an MS Lists list. Each department has an available budget. I want to track this budget. For this, I have an Excel file. With the command "Add a row into a table," I want to enter the price into an Excel list. The problem here is: there are several departments. Each department has its own table in Excel. The tables are named exactly like the departments. In the MS Lists list, there is, for example, the department "IT," and there is also a table named "IT" in Excel.

I want the correct Excel table to be automatically selected, depending on which department is specified in the order process. For this, I can no longer use the dropdown selection in the action "Add a row into a table." I have to enter a custom value.

So far, I have tried the following:

  • Table: triggeroutputs()?['body/department']
  • Row: triggeroutputs()?['body/price']

The following error message appears: Error in action "Add_a_row_into_a_table": The request entity's media type 'text/plain' is not supported for this resource.

The output for "department" from the list is a string, and the price is an integer. Excel cannot process this data. Although both are named "IT," it cannot be assigned.

Does anyone know how I can solve this problem? If not, is there another way to dynamically store the budget in an Excel file?

I am grateful for any help. Unfortunately, I am not a programmer and do not know what to do next.

Best regards, David

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard