web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Creating an Object in ...

Power Apps

Suggested Answer

Creating an Object in a Table Based on Data Selected in a Form

(1) Share

Report

Report

Posted on by RS-03101049-0

2

I want to create an object in a table on my PowerApps page using 3 Text Inputs that are connected to two different tables (Appareil and Activité). Additionally, there are two Date Inputs: the first one captures the Month and Year, while the second one captures the Day, Month, and Year. Based on the selected data from these inputs, the object will be created in the respective table.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi RS-03101049-0,

When you say you want to create an object, do you mean creating a new record in your Data Source?

If yes, you can use the following code (modify it based on your control names) and it should create a record -

Patch(DataSource, Defaults(DataSource), { DateColumn: DateControl.SelectedDate TextColumn: TextInput.Value . . . and so on })

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Niranjanbabu Chakali 23 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Here’s a formula for the OnSelect property of the submit button that handles the object creation logic:

// Extract month and year from DatePicker1
Set(SelectedMonth, Month(DatePicker1.SelectedDate));
Set(SelectedYear, Year(DatePicker1.SelectedDate));

// Extract day, month, and year from DatePicker2
Set(SelectedDay, Day(DatePicker2.SelectedDate));
Set(SelectedFullMonth, Month(DatePicker2.SelectedDate));
Set(SelectedFullYear, Year(DatePicker2.SelectedDate));

// Create object in the Appareil table
Patch(
Appareil,
Defaults(Appareil),
{
AppareilName: TextInput1.Text,
Description: TextInput3.Text,
MonthYear: DateValue(SelectedMonth & "/01/" & SelectedYear) // Example format for Month and Year
}
);

// Create object in the Activité table
Patch(
Activité,
Defaults(Activité),
{
ActivitéName: TextInput2.Text,
EventDate: DateValue(SelectedFullMonth & "/" & SelectedDay & "/" & SelectedFullYear) // Example format for full date
}
);

Was this reply helpful? Yes No

Join the conversation