cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fbxiii
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
fbxiii
Helper IV
Helper IV

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
fbxiii
Helper IV
Helper IV

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

can you share the command did you used ? @fbxiii

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,788)