Cannot see 2nd relation as table view in canvas using switch formula

1

Hi

I have text column with formula:

Switch(
thisRow.Name,
“Table1”,
Lookup(
[Table1],
[Table1].[Financial year],
thisRow.[Financial year]
),
“Table2”,
Lookup(
[Table2],
[Table2].[Financial year],
thisRow.[Financial year]
)
)

I can pull rows from 2 tables now in 1 column.
If i go to canvas view for a row with related rows to table 1 i can switch to table dorm but if i go to a row with related rows to table 2 i don’t have the option to view it in table form.

How do i fix this?

Silhorn.

2

Hi there, thanks for reaching out! Would you mind sharing your doc with the Community by making it public so we can take a closer look at what you’ve already built?

If you’re unable to share your full doc due to security reasons, we totally understand! In this case, we ask that you please set up a demo doc that you’re able to share publicly. This can be a scaled-down copy of the doc you’re working on or just an example doc displaying the issues you’re encountering.

Afterward, please reply with the link to your doc so we can take a look for you.

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.