Create table based on submission

[PushyFurball]

Good morning,

Unfortunately, I have searched for as long as I can stand, which is why I am requesting assistance. First things first.

Details: Creating an app using PowerApps(model-driven) and Dataverse.

Need(s):

I. When you click save, it not only adds the row to the table with the data provided, but also, it creates a new table in Dataverse, either the ID (6-alphanumeric random), or LastNameFirstInitial, with the columns:

- col1(text)

- col2(date)

- col3(percent)

II. Conditional Formatting

- col2(date) if is in the next 60 days - fill yellow

- col3(percent) if below 70% - fill yellow

III. Link new table to original table for certain columns, we can call them col 99,  col88, and col77.

[parvezghumra]

@PushyFurball I'm not I understand your requirement fully, some wireframes of your expected user experience/behaviour of the application might help.

What I will say, however, is that the creation/updating of Dataverse tables/columns (or any metadata, schema) is an activity that should be done by the maker/designer/developer at design-time, not by the user of the application at runtime.

[Fubar]

I would question why it is that you want to create another table? (it is an unusual request and there would be a very limited set of circumstances where this would be a valid approach)

Also, if it is a valid reason be aware that there is a limit to the number of custom tables that you can create.

[PushyFurball]

Let me be more specific. Sorry about that. So, I am trying to convert from Smartsheet to MS to save money, and please keep in mind, besides the Java (beginner and intermediate) classes I took in college, I know next to nothing.

Background Info: I work for a small business (substance abuse facility with 100ish) and this app is going to only be used by 3-4 people at most, HR department.

Design:

- The "Staff List" page will provide a table from Dataverse with employee information, such as Name, contact number, mailing address, employment information, etc.

- Clicking "+New" allows you to input all that information, and whatnot of course, but the reason I need it to create a new table based on name or employee ID.

Reason for New Table:

Since we are a substance abuse facility, we are required to keep all training documentation, such as dates, exam scores, etc., and it also helps us keep track of the Continuing Education Credits (CECs) for counselors and other staff members. The reason it only needs to pull the top row, is because that is the row that will be the most up-to-date.

*EDIT* I provided two pictures of what I have and what I need, and the reason I need the conditional formatting is for the simplicity of scheduling. Again, unless anyone has a better (and hopefully simpler) idea for this.

[MarioRing]

I think we have a misunderstanding here because of the naming convention, and definition of what a table is.

A table (also called "entity") is a structure that represents the business object. Every table has its own name and set of columns (also called "fields") where the attributes, properties, and actual data are stored. Typical examples of tables are Contact (represents a physical person with attributes like name, birthdate, gender, address, phone number), Accounts (for companies: name, tax number, address, type of industry), invoices (obviously - document identifier, total value, seller and customer data.

Every table stores data in the form of rows, often called "records". A record is an instance of an object defined by the table. Sample record for the Contact table may look like this:

First Name: John

Last Name: Smith

Birthdate: 1980-11-12

Gender: Male

Creating a table means to prepare a data structure for the records (creating fields, forms, views and so on). For example, you can create a new table "Holiday Request" and add fields like "Employee", "Start Date", "End Date", "Status".

Creating a record means to fill a previously prepared table with properties of a given object. According to the previous example - the record of "Holiday Request" may look like "John Smith", "2023-08-01", "2023-08-15", "Rejected".

We only create tables during development to prepare a convenient environment for the users, enabling them to create records of tables we created for them. Our applications usually don’t automatically create new tables, but they create new records for previously prepared tables.

As far as I understand you want to create an app where you store (in tables;)):

• Employees of your organization

• Training records related to them

Additionally, you want to create automation that triggers every time you add a new Training record, which should update the related Employee record. For example - if I add new Training record to my Employee John Smith, the system should automatically update the field "Last training date" on John Smith's Employee record. 

Beyond that you want to use some color coding to highlight data if it meets relevant conditions. 

Am I right?