Dereference using SELECT

Here is regular formula for Same App
SELECT (Table Name[Column Name])

How do I create formula to pull data from. Another App

Any idea?

@Amit_Jain
You need to add that another app’s table that you need as a table to your app.

It worked

Thanks for reply

One more Issue
I also want to Add “Blank” & “Plain” in Every dereference Result along with Match result

The results of a SELECT() are in a List. You can combine lists using the + operator (see the link below), so you can use + to add more items to your results, similar to this:

SELECT(...) + LIST(...)

Note, though, that the items you add should be the same type as the items in the first list: in this case, you should add references to rows for Blank and Plain, not just the words.

Once again Thank for Suggestions

1 Like