Answered

Add Date stamp to SharePoint list which also has an email in the same column

(0) Share

Report

Posted on by Uddinf

Hi,

I am a new user, can someone please help me with this query. I've tried number of different ways however cant seem to get the result I'm looking for.

I have an App, that users can a unbook a session from clicking a button, once cancelled I would like to record the users email, date and time of when they have cancelled.

The patch below works and adds the email address to Sharepoint list 'session'

Patch(
[@Sessions],
First(
Filter(
[@Sessions],
ID = ThisItem.ID
)
),
{'Cancelled Bookings': User().Email & ", " & ThisItem.'Cancelled Bookings'}
)

I would like to add the date and time alongside the email address in the same column on SharePoint. what's the best approach to do this ? can I amend this patch to include the date and time ? The SharePoint column setting is set-up as 'multiple line of text' do I need to change this ?

Thanking you in advance.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Uddinf

SharePoint has a metadata field Modified that automatically saves the last date and time that the record was changed. It also has a 'Modified By' field that records the DisplayName and email of the user who made the change

ThisItem.'Modified By'.Email
Uddinf 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
Thanks for getting back to me. Its not exactly what I am looking for. The App is used to book users on a training a course , it records the name of the user and the session they have booked for . Now when users cancels a session via the App it removes the name from the booked column to the cancelled booking column for the session

The email has been moved from ‘Booked attendees’ to Cancelled Bookings’ , what I was planning to do is add a datestamp next to the user user name , so when the button ‘Unbook Session’ is clicked we also know the info when the user has unbooked.

I was trying to patch the date and time without any luck.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Uddinf

The OnSelect property of the Unbook button:

With({timestamp: User().Email &", ",Now()}, Patch([@Sessions], LookUp([@Sessions],ID = ThisItem.ID),{'Cancelled Bookings':timestamp}) )
Uddinf 11 on at

Like
a
(0)

Report
Copy link

Link copied!

hi , i have replaced my patch :
Patch(
[@Sessions],
First(
Filter(
[@Sessions],
ID = ThisItem.ID
)
),
{'Cancelled Bookings': User().Email & ", " & ThisItem.'Cancelled Bookings'}
),

with your one

); With({timestamp: User().Email &", ",Now()},
Patch([@Sessions], LookUp([@Sessions],ID = ThisItem.ID),{'Cancelled Bookings':timestamp})
),

it seems to throw me an error . Is there something im missing?
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@Uddin

There was a typo.

With({timestamp: User().Email & ", " & Now()},
Patch([@Sessions], LookUp([@Sessions],ID = ThisItem.ID),{'Cancelled Bookings':timestamp})
)
Uddinf 11 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked perfectly, thank you so much 😊