Power Platform Community Forum Thread Details

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

Categories:

Building flows