cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lorem1960
Resolver II
Resolver II

unable to open my details form from my datatable??

On my DataTable: DataTable1 I have the following action:

 

Lorem1960_0-1635250616338.png

 

This should open the FormDetails in Edit mode, but I noticed this error on Item on FormDetails:

 

Lorem1960_1-1635250760847.png

 

I tried putting SelectedRecord but that doesn't seem to work either?

 

I really have no idea what is the cause of this error.

 

Thx.

 

11 REPLIES 11
C-Papa
Super User
Super User

hi, try the below:

 

Set(SelectedRecord,DataTable1.Selected);EditForm(FormDetails); Navigate(FormDetails,ScreenTransition.None)

 

And set the items to 

 

SelectedRecord

tried that as well, same error message.

C-Papa
Super User
Super User

ok, try the following

Set(SelectedRecord,DataTable1.Selected);EditForm(FormDetails); Navigate(FormDetails,ScreenTransition.None)

 

set the items to 

LookUp([DataSoruce],ID=SelectedRecord.ID)

 

where [DataSoruce] is you datasource name

 

 

 

 

This is what I get when trying to the Lookup function:

 

Lorem1960_0-1635254052556.png

 

You haven't add what i put, it should be

 

LookUp('Pending Procurement Receipts',ID=SelectedRecord.ID)

Lorem1960_0-1635254424658.png

 

C-Papa
Super User
Super User

What data source are you using? 

 

Does this work

 

LookUp('Pending Procurement Receipts','PR #' = SelectedRecord.'PR #')

When I hover over the = I get the following error:

 

Incompatible types for comparison. These types can't be compared: text, error

C-Papa
Super User
Super User

can you paste a picture of the form you have selected and the property code that is causing an issue, in one big picture. there is something else going on here that is stopping this from working. What is you data source? 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,212)