Gallery showing selected data from another gallery

[Anonymous]

If I want a gallery to show the item/data which has been selected in another gallery, I usually use the formula: Filter(Data source,ID=' Gallery'.Selected.ID), this usually works fine for me, however, I’m having issues replicating this across a new data source I’ve added.

The formula I’m using is exactly the same as usual: Filter(ZapierTrackerFront,ID='Role Tracker Gallery Search'.Selected.ID), however, the formula is not accepted, I’ve tried many alternatives, but all still no luck. The formula error messages which appear are attached as well as the data source I’m trying to link.

Any idea’s how I can solve this, please? Is this an issue with the data source? And is there a formula/solution I can potentially look to use rather than the above?

Data source: ZapierTrackerFront

Gallery: Role Tracker Gallery Search

[zmansuri]

Filter(Data source,Value(ID)=Value(Gallery.Selected.ID))

[RandyHayes · Accepted solution]

@Anonymous 

Your Tracker Zapier Version excel file does not have an ID column in it!!

If it is the Job ID that you are interested in, then change your formula to the following:

Filter(ZapierTrackerFront, 'Job ID' = 'Role Tracker Gallery Search'.Selected.ID)

I hope this is helpful for you.

[Anonymous]

Thanks @zmansuri! However still no luck when trying that formula, am I doing something wrong? Error message is attached. 

[RandyHayes]

@Anonymous 

And did you notice that I mentioned that you do not have an ID column in your datasource based on what you sent in your post, so that formula will never work!

[Anonymous]

Amazing, thank you @RandyHayes! I tried the above and am now receiving the attached error message which looks to be an issue with my data source in Excel which I need to look into.

[RandyHayes]

@Anonymous 

Ah, I was rotating through my post responses and saw yours and replied before seeing your latest.

Yes, you are now seeing a delegation warning.  If you are using the suggested Value functions from the other post, then you'll definitely want to remove them.  However, that is not so relevant to the delegation as Excel is a non-delegable datasource, but more to simply never using those type of functions in a Filter as they will almost *always* lead to Delegation issues when working with real delegable sources.

So, again - Excel is non-delegable, so you will receive those warnings!

Glad to help!

[Anonymous]

Thanks @RandyHayes, really appreciate the help!