Importing into a list based on a specific value of the parent

Options
EHarris
EHarris Member, ALL USERS, GroupMember, Partner, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

Hi,

 

I'm trying to add functionality to a model where G3 items in a list are deleted and replaced with other items in that same list.

The model has the following Hierarchy:

G3 Hierarchy.JPG

In the G3 list, each Resource is either a resource in the current scenario or in the future scenario, this is achieved by the 'Type' property:

G3 List.JPG

On a dashboard accessible by end users, there will be an action that deletes the current resources for a G2 site, and imports the future resources into the current resource property. I thought the best way to do this was by:

 

Import G3 Resources into a module --> Delete all children of the G2 site --> Import Current Resource (formerly Future) back into that G2 Site from the module.

 

The actions above will update the entire G3 list (for all sites). How can I create an action to import only the G3 Resources for one specified G2 Site?   Is there a better way to achieve the functionality?

 

 

Thanks

Comments

  • EHarris
    EHarris Member, ALL USERS, GroupMember, Partner, Community Member, Certified Model Builder Posts: 5 Occasional Contributor
    Hi @LIPCheap_Soh,

    The model is a tool for end users to compare 2 different resource scenarios. End users add their current resources and their future resources to list G3. If they're happy with the future scenario and plan to implement it in their area, we'd want an action to delete the current scenario and replace it with the future scenario.

    This means next time they open the tool, they wouldn't have to re-enter their current resources from scratch.

    Thanks