Power Platform Community Forum Thread Details

Hello community,

i am kinda new to the Powerplattform and have the follwing situation to be solved, which i am not kinda sure which is the best way to do it.

The following fields should be stored to the Dataverse, filled in by a Powerapp Form

Request date
User name
Manager name

Request ID

Attachment

For each Request there should be the possibility to store one or more of the following field entries

Request Type

Start Date

End Date

So my question is.
Do i have to create 2 Entities in Dataverse like the following?

DataTable 1 (e.g. Requests)

Columns

Request date

Username

Manager name

Request ID (related to Request ID of DataTable 2)

Attachment

DataTable 2 (e.b. Request Time Table)

Columns

Request ID (related to Request ID of the DataTable 1)

Request Type

Start Date

End Date

Is that correct or could it be done another way in Dataverse?

When i now create the PowerApp Form to fill the Data, what´s the best way Todo it?

Create a Form bound to DataTable 1?
Whats the best way to add Data for the DataTable 2?
I want to add 1 or more RequestTypes entries to the Powerapp but it should not be stored to the Dataverse until i hit the save button, which stores the whole Record (Entry to DataTable 1 und 1 or many related Entries to DataTable 2).

I hope my request is somewhat understandable :).

thx in adv.

Categories:

Building Power Apps

Hi @MB29 ,

If I understood correctly, you want to use a Request Form in Power Apps to fill in data and update to Dataverse, right?

If so, I am wondering will there be so many different request types for users to type in? Usually, columns like "Types" or "Status" should pre-define values for user to select from, rather than let them input and save to data tables without any limitation. As a result, we usually use Choices type columns, pre-populating all selections that needed.

So if using Choices column, you will need to create only one table in Dataverse:

Table: Requests

Columns

Request date

Username

Manager name

Request (LookUp column, relates to Table1)

Start Date

End Date

Request Type (Choices type column, with all choices there could be)

Attachment

Now you could connect an Edit Form in New Mode with this Table by setting DataSource property of the Form to the table name "Requests".