Is There a Better Way to Reference Related Items from Results of Get Items from a Podio View?

Comments

4 comments

  • Bill Carovano

    I am thinking you'd adjust your data model slightly, whereby your Accounts app has a relationship field pointing to the Email Lists app.  (this works around the 250 related items issue you mentioned, which is a "forward" relationship limit, not a "reverse" relationship limit).  And then your flow on the Accounts app could do a forward Get Referenced to update any related Email List items for the Account 

    1
    Comment actions Permalink
  • Bill Carovano

    Hi Chris - regarding your statement "The root of the problem seems to be that I can't continue a reference forward when doing a Get Items from a Podio View"

    The workaround for this is to use "run flow on collected" within a loop that processes the items you get from your view.  That way the forwarded related apps/items from each collected item can be referenced using "Get Referenced" directly, because the flow is now running in the context of the collected item's app.

    Let me know if that helps, or if I can offer further clarification.

    0
    Comment actions Permalink
  • Chris Foley

    Hi Bill,

    Thanks for the help.  I'm not sure how I can update the original item once I'm in the flow I triggered on the referenced item.

    For example, lets say I start in the Email Lists app/item and my end goal is to populate a text box in the Email List item.  I get a list of Accounts by doing Get Items from a Podio View.  I then loop through each Account that is returned and trigger a flow on the Account.  The flow that is triggered in the Accounts app can reference the related Contacts app from Accounts and get the necessary info (email, first name, last name) from each Contact related to that Account.  But then how to I get that contact information back to the original Email Lists item?

    Thanks!

    0
    Comment actions Permalink
  • Chris Foley

    Thanks Bill.  I made those updates and it is definitely a cleaner solution.

    It's still fairly slow when I have a lot of matching Accounts, but I'm guessing that is just the nature of updating lots of items.

    Thanks for your help!

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk