I have a Flow table property containing some base data for a customer. I would like it for them to be able to edit this table themselves without having to go into Flow Studio by building an admin workflow for them. Is there a way to edit table properties by using the Flow connector? I know that it’s possible to change the personal properties of an individual user, or to change a global property, but I don’t see any way to edit a table property.
I also had the idea to just drop and re-create the table property, but that doesn’t seem possible either. Am I missing something or can’t this be done?
Hi,
I would recommend using a database that is better suited for transactional data for the purpose. MS SQL table for example. This is so that it will not lock up the SQL lite database unnecessarily.
But I think you are right, there does not seem to be a way to update a specific row in a table property using the flow environment connector.
The delete property, does that not work on table properties?
Unfortunately we don’t have easy access to an MS SQL database. This is a bit of an edge case where it really isn’t worth setting up a bunch of new stuff just for this one solution.
The delete property function probably works, but I don’t see a way to then create the property table anew. There is a function for creating new properties, but based on the syntax I don’t really see a way to create a table by using it.
I guess I’ll just have to inform the customer about how to manage the table themselves in Flow Studio.
it is possible to read and change the User table property, its just that…its a bit weird (and takes some manual work )
So when reading it
you can use the environment connector / properties / get user properties
but you will notice that what you get back is a string, separated by chr(30) and chr(31)
So to have this string editable for the users you must do some scripting (back in the day i did it using split and manualy creating tables with exact number of columns needed, i guess there could be a better way now) making it a flow table to show in a user step.
And then after you need to revert the proccess and turn your table into a string (by adding chr(30) and chr(31) at the right places) before saving it to the same property using the environment connector / users / Set value of property on user.
In attach is my old example.
(As Ola mentioned these are not meant to store a lot of data)
)
