I've set up a system in which there's a directory sheet that has numbers associated/linked to different worksheets.
My first form to excel power automate, does the following...
Gets number (Example 244) from form -> input number (224) into directory table on the directory worksheet -> creates a new worksheet with that number (244) -> creates a table called _244 (done through entering _[number from form]).
This all flows perfectly so a new row, worksheet and table are put in as I wanted.
The problem that I'm now facing is I want to fill out the tables I've created in the new worksheets through another form and power automate.
I've tried putting the table name as _[Number from form] which is the exact table name that the new table created has. But it won't flow through properly.
The error message is the following:
The request entity's media type 'text/plain' is not supported for this resource.
I'm assuming this means that despite it resulting in the correct table name it won't use the title and input the data as I hoped.
Why it's needed like that is so that staff can enter in the details into the newly created sheets directly after creating the new sheets, there isn't time for someone to create a whole new form/flow just so that they can enter this information. Also because of the importance of the data we wanted to turn off editing for general staff meaning the only way they can input the data is through the forms (to avoid data being accidentally changed).
If I can't add the new row into the table because of the limitations on the name of the table does anyone have any suggestions how else I could best do this?