Link in DataTable stops working after modifying with AddColumns()

[donalmcnamee]

I've got a DataTable with one cloumn HyperLink enabled.

When the user clicks on the HyperLink, it brings them to another screen where they can modify the record as per the DataTable. 

This all works fine. However, when I AddColumns() to the DataTable and then click the HyperLink, the modify screen gives an error:

Invalid Formula: Expected a value compatiable with 'DataSource'

What's going on with AddColumns() that's causing this error?

[WarrenBelz]

Hi @donalmcnamee ,

That is because the added column is not available for the form - you need

Filter(
   DataSource,
   ID=PartsTable.Selected.ID
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[donalmcnamee]

@WarrenBelz 

So I've changed Item on the Form to now read:

Filter('public.parts', ID=PartsTable.Selected.ID) 

 But it's complaining about Incompatiable types for comparison. 

Is there something else I'm missing?

[WarrenBelz]

@donalmcnamee ,

Very strange - I am assuming 'public parts' is a SharePoint list, therefore will have a numeric ID and PartsTable is a Gallery based on the same list - is this not correct?

[donalmcnamee]

@WarrenBelz 

'public.parts' is a PostgreSQL table that I'm accessing via a Gateway. 

The ID on the table is 'id' (note that it's lower-case).

(Following is a screen-shot of the table structure for 'public.parts' in PostgreSQL)

I though it may have sometihng to do with case (ID vs id) but it dosen't seem to make a difference. 

Just to confirm, PartsTable is a Data Table based on 'public.parts' and not a Gallery

[donalmcnamee]

@WarrenBelz 

I got this working, but I'm not sure it's the most elegant solution. 

In OnSelect in my DataTable I have: 

Navigate(
	Form2,ScreenTransition.Cover,{
		selectedId:Value(PartsTable.Selected.id)
	}
)

In in my form for Item I have:

LookUp('public.parts', id=Value(selectedId))

[WarrenBelz]

@donalmcnamee ,

Pretty much the structure I posted except you did not tell me your data source was SQL - I was assuming SharePoint as you used ID.