Hi All, I am trying to create a table with the columns that are generated at the time of running of work flow and insert values into that entity table. So, for example, I have a table with columns called quantity1, item1 and item2 that are generated at the time of the workflow (column names and types), so I need an entity table created with these column names. Because there are no activities in the Data Service package that seem to support this.
Unfortunately you cannot create a new Data Fabric entity in real-time using activities. The entity needs to be created and pre-defined (with column headers and data types) before you can update or modify it using UiPath activities.
I understand why you would need it, but theoretically it’s a safety net to prevent incorrect data types and unnecessary entities being created all the time.
Let me know if I understood your request correctly.
Hi @JarrydScott, THANK YOU FOR YOUR RESPONSE. Yes this was the query I had, and i do agree that it is a deficiency that needs to be addressed.
There is no way to create dynamic datatable to create in data fabric.
Instead of that, create a entity table manually with required columns.
At the time of workflow create a data table with required columns
then convert each row as json string and use Create Entity record Activity.
Happy Automation