-
Hey, perfect, glad you have it working the way you want!
-
I figured it out by combining Ernosto's and Hillary solution. Below is what I did.
I created a new SharePoint list called Teams and associated each user to a teamI added the list Teams as a seconary data source to the formI added a new field called myTeam to the main datasource that with a default value from the Teams datasource with a filter ...
-
-
Forgive me for barging in.
If you create a list that associates users to teams, you should be able to do this.
Add a data connection to your new list (with user and teams). The condition on the repeating table would be something along the lines of:
If Team is not equal to Team (from SharePoint List) where User (from SharePoint List) is equal to ...
-
This looks right - the Refresh command is on the finishedLoading node, so would execute before anyone would be able to delete anything & you have an ID field indicated, which you'd need for the refresh. I'm assuming you are executing the SubmitToSharePointList command again prior to expecting items to be deleted.....
Is this in ...
-
I'm confused, because the original table shows a relationship between Items and Teams, not Users and Teams.
Where do you store the relationship that tells us which Users belong to which Teams?
-
Thanks for the suggestion - I've added this to our bug tracking system as a possible future feature!
-
Back to my original question. Is possible to filter information in a repeating table for a person based on their association to a team and if so any suggestions on how to accomplish this?
I would prefer that the relationship between the user and the team stored in SharePoint.
-
-
Oh I see.
I honestly don't know. Where do you store the relationship between People and Teams? SQL? On a ShP List? In Active Directory?