cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
fbxiii
Level: Powered On

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
Level: Powered On

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
fbxiii
Level: Powered On

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

azzamkaz
Level: Powered On

Re: Show selected record from Datatable on a form

can you share the command did you used ? @fbxiii

fbxiii
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 338 members 5,088 guests
Please welcome our newest community members: