cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Show selected record from Datatable on a form

I am creating an App that should allow users to Add comments to 'Notice board' entries.  I have used the Sharepoint list template which displays the main 'notice' from the list.  I have created another list to store the users comments which has a column to hold the Notice ID to link the comments to the right notice.

 

The comments are shown in a data table on the detail screen.

 

I can select the comment and pass the ID from the comments list (comment ID, not notice ID) to a new screen but I can't get the filter working to display the selected comment.

 

Filter('Notice Board App Comments List',ID = CommentID)

 

I get an Information icon saying The property expects Record values but the rule produces incompatible table values.

 

This seemed like a simple thing to do but has left me scratching my head.  Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Helper IV
Helper IV

Re: Show selected record from Datatable on a form

Answering my own question.   I simply need to reference the DataTable.Selected in the Item property on the form viewer in the new screen.

View solution in original post

3 REPLIES 3
Highlighted
Helper IV
Helper IV

Re: Show selected record from Datatable on a form

Answering my own question.   I simply need to reference the DataTable.Selected in the Item property on the form viewer in the new screen.

View solution in original post

Highlighted
Helper III
Helper III

Re: Show selected record from Datatable on a form

can you share the command did you used ? @fbxiii

Highlighted
Helper IV
Helper IV

Re: Show selected record from Datatable on a form

I put DataTableName.Selected in the forms Item property.  Although I think I took a different approach in the end and used a Gallery instead.

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 (8,013)