I have the following scenario:
2 SharePoint Lists, 3 collections, 1 gallery, UserId stored in a variable
When a user selects the '+' icon I wish to patch the SessionRegistration list
I have tried numerous formulas without success.
Solved! Go to Solution.
How would you define the 30 or less people signed up for that session? Using which column in colMeetingSessions? I think it would be better if you could share some data examples for all the involved data sources in this app. Some screenshots would also help. Do mask sensitive data before uploading.
Updated - in original photo, i said sessionId = sessionCode. It was meant to be does not equal.
Basically, only patch if the user is has not already registered for the selected session. I do not want to allow a user to duplicate signing up for a session and I need to stop allowing users to sign up for a session once 30 people sign up.
@v-monli-msft Thanks for your reply. I hope the screen shots help.
How would you define the 30 or less people signed up for that session?
Using which column in colMeetingSessions? Meeting Sessions is not being referenced for the count.
MeetingSession is only for the collection displaying all the sessions for the meeting and is not being updated or patched..
The column being referenced will come from the colSessionRegistration, count UserBid IF the SessionCode from the glrAgenda.Selected.SessionCode (items = colMeetingSession) is equal to the colSessionRegistration.SessionId.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand