We are using SwithIf function to copy canvas from one table to another. The core idea is to use canvas from table 1 as a template for canvas in table 2. Inside mentioned canvas we would like to use table view, which is brilliant feature and working well within parent canvas (to be used as a template), however, when copy table from canvas to another table canvas, object is not found.
One more thing, when new table is made in parent canvas, copy canvas make new table without any properties of previously made table.
I understand that second topic could be challenging to apply, however copy table view to another canvas could be fixed.
Hi Andrejs,
Welcome to the community!
Could you share a view of a document illustrating your problem, it is very difficult to respond purely based on a message.
In the meantime, @Nina_Kastenauer has created an excellent tutorial on the topic:
Regards
Piet
Hy Piet,
Thank you for support! Somehow i figured out the issue by using tutorials from @Nina_Kastenauer and @Mike_Ray.
Here is a link to solved sample:
In short, when using filter the result is a list but not a unit to link. So I’ve solved it by using .First() function. Here is a code sample:
SwitchIf(
thisRow.Project=
Projects.filter(
Name.Contains(
trim(thisRow.Project)
)
).First(),
Projects.filter(
Name.Contains(
trim(thisRow.Project)
)
)
.First()
.Notes
)
However, in case of using this formula, canvas are not editable. (((
1 Like