cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AVTS
Super User
Super User

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
Super User
Super User

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,020)