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

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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

secondImage

New Return to Workplace

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

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,341)