cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AVTS
Post Patron
Post Patron

Canvas App - Selected line display in the field

 

How to display the selected item from the datatable in to the field.

 

AVTS_1-1621022032462.png

 

Example : if you select sno 0004 then materialno should display in Pointer1 and Qty should display in Pointer 3.

 

Another requirements i need to update the same into the table instead of saving.

 

Below is the save formula which should update instead of saving.

Patch(Dailyinventory,Defaults(Dailyinventory);{Materialno:Dropdown1_2.Selected.Materialno,Materialdesc:Label2_2.Text,Qty:TextInput3_2.Text,BBD:DatePicker1_3.SelectedDate});
Reset(Dropdown1_2);Reset(TextInput4_4);
Reset(TextInput3_2);Reset(DatePicker1_3);

 

How to acheive this.

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @AVTS,

Do you want to populate the Dropdown1_2 with the DataTable selected?

Could you please share a bit more about the scenario?

Set the Items property of the Dropdown1_2 as below:

Distinct(Dailyinventory,Materialno)

Set the Default property of the Dropdown1_2 as below:

DataTable1.Selected.Materialno

So does the other two field value following as:

DataTable1.Selected.FieldName

In addition, do you want to update the DataTable1 selected record?

If so, you should modify your formula as below:

Patch(Dailyinventory,DataTable1.Selected,
{Materialno:Dropdown1_2.Selected.Result,
 Materialdesc:Label2_2.Text,
 Qty:TextInput3_2.Text,
 BBD:DatePicker1_3.SelectedDate}
      );
Reset(Dropdown1_2);Reset(TextInput4_4);
Reset(TextInput3_2);Reset(DatePicker1_3);

Regards,

Qi

 

Best Regards,
Qi

View solution in original post

2 REPLIES 2
AVTS
Post Patron
Post Patron

Team i am able to display the datatable item in to respective items,

example :

DataTable1_2.Selected.Materialno

 

But i am trying for update in to the table with revised data. i could not. please give me some heads up on the table update

v-qiaqi-msft
Community Support
Community Support

Hi @AVTS,

Do you want to populate the Dropdown1_2 with the DataTable selected?

Could you please share a bit more about the scenario?

Set the Items property of the Dropdown1_2 as below:

Distinct(Dailyinventory,Materialno)

Set the Default property of the Dropdown1_2 as below:

DataTable1.Selected.Materialno

So does the other two field value following as:

DataTable1.Selected.FieldName

In addition, do you want to update the DataTable1 selected record?

If so, you should modify your formula as below:

Patch(Dailyinventory,DataTable1.Selected,
{Materialno:Dropdown1_2.Selected.Result,
 Materialdesc:Label2_2.Text,
 Qty:TextInput3_2.Text,
 BBD:DatePicker1_3.SelectedDate}
      );
Reset(Dropdown1_2);Reset(TextInput4_4);
Reset(TextInput3_2);Reset(DatePicker1_3);

Regards,

Qi

 

Best Regards,
Qi

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,782)