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

Connect edit form datacard to a data table

Hello,

 

I have a  multiline text field in a edit form on screen 2 , I need to link this field to an item selected in a datatable on screen1 so that when user inputs comments in this field it saves in the same item which is selected in the datatable on screen1.(the fields in screen 1 and screen2 are different).  Please let me know

 

Thanks,

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Connect edit form datacard to a data table

Hi @ck25415,

 

Could you please explain a bit for:

"

so that when user inputs comments in this field it saves in the same item which is selected in the datatable on screen1

"

Does the Multiline TextInput need to save the data to the data source configured under the DataTable, or just need to show its Value under the DataTable?

 

For the DataSource update, we could take use of Patch() function, when submitting the Form changes.

Patch(DataSource, Lookup(DataSource, Field=DataTableFieldValue), {Field:ValueUpdate})

If you would like to show the value under the DataTable, but not save it to the data source, then please change the Text(Or the Default ) Property of the Field with:

DataCardValue.Text

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Post Patron
Post Patron

Re: Connect edit form datacard to a data table

Hello Michael,

 

I wanted to save the data to the datasource under the datatable so I have used the lookup function. I did not use the patch function along with lookup. below is the expression I have used.

 

Lookup( datasource, ID=datatable.selected.ID)

 

Its working for me, let me know if there are any improvements.

 

Thanks for the support.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,231)