another scenario - patch one 1 slot taken and also able to return back and user email - how to??

[bbsin]

Hi

I have another issue 

I have two list - admin list to input the total of slot available and track

user list when user book or unbook the slot.

A is an input box, - to default as 1

how to patch slot take that is 1 to admin list and B will should the reminder out of the total 

when the user click unbook, this record should delete and return the 1 slot back to the total of the admin list and remove the slot taken; user record should be removed in the user list too?

Do I need to set Variable somewhere? 

Patch(Admin,  {NumberofSlotTaken: NumberofSlotTaken - inputtextA.text});

Patch('user, Defaults('user'), {Title: Title.text, NumberofSlotTaken: ...});

Also how to patch by the reservedby - user email into the list?  It's Person/Group field in SP list.  

Thanks

[v-albai-msft]

Hi @bbsin 

Are you doing this inside a gallery that is connected to the Admin list?

Is your B a Label? What is the formula for B?

Assume that you are editing inside a gallery, so:

For Patch button, do you want to edit the slot value for the selected item in Admin list and also create a new item in user list? If yes, you can try this formula:

Patch(Admin, Lookup(Admin, Title=ThisItem.Title), {NumberofSlotTaken: NumberofSlotTaken - inputtextA.text});

Patch('user list', Defaults('user list'), {Title: ThisItem.Title,ReservedBy:{'@odata.type':  "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & User().Email,
DisplayName: User().FullName,
Email: User().Email},
NumberofSlotTaken: ...});

Note: to add current user into the ReservedBy Person column, you can use formula like below inside Patch function:

ReservedBy:
{'@odata.type':  "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & User().Email,
DisplayName: User().FullName,
Email: User().Email
}

For Unbook button, do you want to edit the slot value for the selected item in Admin list and also removed the corresponding item in user list? If yes, try this formula:

Patch(Admin, Lookup(Admin, Title=ThisItem.Title), {NumberofSlotTaken: NumberofSlotTaken+1 });
RemoveIf(‘user list’,Title=ThisItem.Title)

Best regards,

Allen

[bbsin]

Hi Allen,

Thanks Let me try to input your suggestion.

B formula is ThisItem.TotalofSlots - ThisItem.NumberofSlotTaken  -- SP list is number.. should I change this too??  Thanks

I must hv done something wrong.. 

Do I need to set a variable somewhere.. if not how to patch the date and and time too?  Thx 

[v-albai-msft]

Hi @bbsin ,

What is your issue now?

Which date and time do you want to patch? If you want to patch the time like "12:00 to 13:00", just add a new Text column in your SP list, for example called "TimeText", then in the Patch function, use formula like this:

...

{

...

TimeText: Text(ThisItem.DateBooked,ShortTime24) & "to" & Text(ThisItem.DateClosed,ShortTime24),

...

}

...

Best regards,

Allen

[bbsin]

@v-albai-msft 

the date time column is set in SP as Date - Field DateTime for Datebooked and DateClosed

Do I need to break into date for day and any column for Time?

if not how I can just patch as Datebooked: Datebook.selected.DateTime??  NOt sure how to patch it.

[v-albai-msft]

Hi @bbsin ,

Do you mean this DateTime column is a Date column including time in your list? And do you want to patch a date with time into your list? 

What is your Datebooked? Is this a date column in your SharePoint list or a DatePicker control in your app? 

Best regards,

Allen

[bbsin]

Hi @v-albai-msft 

Yes both are datecolumn SP list

There's no date pick in PowerApps.  

it's just a display 

Text(ThisItem.DateBooked,ShortTime24) & " to " & Text(ThisItem.DateClosed,ShortTime24)

Regards

[bbsin]

Hi @v-albai-msft 

what did I patch wrong?

The book is always to be 1 slot taken from total  

and unbook to return the 1 slot.. 

if I put  {NumberofSlotTaken: NumberofSlotTaken - InputSlot.Text});  also cannot work

I want to remove the arrow but  I hv set varBook, this item.  is it ok to remove it?  I don't  need the arrow.  thanks

[bbsin]

Hi Allen @v-albai-msft 

Can you kindly help. I cannot patch it.. 

If I use this to patch is ok (I saw fr Shane video) but I cannot patch the user email; name and department with the syntax you provide. can you advise thanks

and the unblock button too thanks

my gallery infront is using 

 and it works.. does it link to patch also??  this syntax I try to input the same it cannot work.  Please help..  Thank you

[v-albai-msft]

Hi @bbsin ,

Due to my carelessness, I missed three property in my previous code, so try this(missing Department, JobTitle and Picture property):

ReservedBy:
{'@odata.type':  "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & User().Email,
DisplayName: User().FullName,
Email: User().Email,
Department: "",
JobTitle: "",
Picture: ""
}

Don't hesitate to let me know if you still have trouble about this question.

Best regards,

Allen