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

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.

azzamkaz
Level: Powered On

Re: Show selected record from Datatable on a form

can you share the command did you used ? @fbxiii

Highlighted
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
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 264 members 4,480 guests
Recent signins:
Please welcome our newest community members: