Solved: SharePoint (PowerApps Form) UpdateIf Function

SharePoint (PowerApps Form) UpdateIf Function

Hi Team,

I need help on below case. I have 2 list (Session details & Registration form list). In the form (Customized Form), I will fetch some details such as (Course Name, DateTime, Available Seats, ID) from List A (Session) via dropdown field. So user need to select which course first then DateTime will reflect at dropdown list based on the course name selected on above. After they select the DateTime, the Available Seats and ID will reflect at another dropdown and textbox (ID).

The function is when they select the particular course and time, it will check whether the available seats are still available or not, if still available, user can able to submit for the registration. After they submit, it required to update value as increment +1 at Current Reservation column at Session list.

The problem statement is If the Course C has 2 different date & time (5pm & 6pm), when I submit for 5pm, it successfully updating the Current Reservation +1 value. After that if I submit for 6pm for 1st attempt, it will still update at 5pm record instead of 6pm. But, for 2nd attempt and onwards, it will update correctly at 6pm. If I update again to 5pm, then it will update at 5pm record. Course C has 2 records and 5pm is 1st record and 6pm will be 2nd record.

Below will be the UpdateIf function code that I added at Submit button under OnSelect setting :

SubmitForm(SharePointForm1);

UpdateIf(
Sessions,ID = Value(DataCardValue8.Text), {'Current Reservations':'Current Reservations' + 1});

**DataCardValue8 is Session ID Textbox field**

Kindly refer the attachment of the list view and form view

Let me know if you need further details.

Regards,

Baradt

Categories:

Solution Explorer

Entities

Quick Links