I have this relationship in Dataverse:
Meetings <-many-----many-> Employees
and a gallery where I'd like to list those that were not at a meeting.
Since I cannot do an outer join directly on Dataverse, I used the following strategy:
However, the gallery that I have linked to absent is displaying all employees.
Apparently, Remove(all, attendants) is not removing.
I've tried several variants, such as:
Remove(all, myMeeting.Employees, All)
But none yields the expected result, they either show all employees or a gallery filled with empty entries.
Why is that? Any hint?
Thanks in advance.
Solved! Go to Solution.
I don't see where you are actually collecting any information into 'absent'. Where is absent supposed to get it's data?
Thanks for your reply, @JR-BejeweledOne .
In response to your question: it's the 3rd statement that is setting absent:
I'm trying to assign to it all employees except those in attendants.
I believe I'm using this syntax of Remove (al least, studio tells me that attendants is being interpreted as a table):
Remove( DataSource, Table [, All ] )
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT