Hello everyone,
I have two tables in dataverse that has the below custom columns:
Table 1: (Form Template)
Form Template Result (Fields that should be created from the form template table)
What I want to achieve is the below:
1. I want to populate some custom table names in a lookup column inside the form. (In our example the custom "Form Template Result" table mentioned)
If it's not possible to populate the table name in the lookup column we can use a choice column with hardcoded-name for the tables to avoid using a Text field because the users may write the wrong table name.
Scenarios:
On Add:
2. When the user fills out the form in the form template table I want to create that dynamic field in the table selected.(In our example the custom "Form Template Result" table mentioned)
On Update:
3. If the user added to the "Form template result" table a text column, then he decided to change and modify that column data type to be DateOnly, the form should be affected and the data type will be changed on update.
The same goes if he also decides to rename the attribute or assign it as required.
The purpose of the above is to allow non-it users to create any fields needed to the table they select from the lookup/choice column.
What is the best and efficient way to achieve the above?
Can please someone provide an example with the steps needed?
I read the documentation about Create columns using web API. But I want to see an example of how to call this API onsave event of the form and the other requirements mentioned.
Would highly appreciate if you can assist and any help is highly appreciated.
Thank you!
