add date to SPL when button is pressed

(0) Share

Report

Posted on by ghostdragon

I have a Power App where I'd like to write a date back to a SPL when a button is pressed.

Screenshot 2023-03-20 at 21.35.58.png

So you choose a date, press "start session" and it'll write that date back to a column named "Date" on my SPL.

Any help greatly appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

zuurg 546 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

In the button's OnSelect you want to tell it to patch your record. The 2nd argument for patch will be how you locate the recordm such as LookUp(SPLname, ID=Gallery1.Selected.Id) or something along those lines:
Patch(SPLname,LookUp(SPLname,ID=Gallery1.Selected.ID),{Date: DatePicker1.SelectedDate})

Was this reply helpful? Yes No
ghostdragon 9 on at

Like
a
(0)

Report
Copy link

Link copied!

What does ID=Gallery1 refer to?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ghostdragon,

I think @zuurg wants to confirm with you that if you want to update an existing record or create a new record when you press a button.

If you just want to create a new record to your list, you just need to:

Patch(List,Defaults(List),{Date:DatePicker1.SelectedDate})

Note that I assume that you Date column is a Date only column type, if it is single-line-of-text, you need to format the selected date into text string as beklow:

Patch(List,Defaults(List),{Date:Text(DatePicker1.SelectedDate,"dd/mm/yyyy")})

Was this reply helpful? Yes No
ghostdragon 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft

Ah I thought I had it but I now get an error which says 'Network error when using Patch function: Field 'Title' is required.'

OnSelect on button is Patch(Pool,Defaults(Pool),{Date:DatePicker1.SelectedDate})

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ghostdragon,

That's easy, you just need to put your Title field because SharePoint recgonize it as the Required by default.

If you don't want it to be a required column, go to the list settings and change it into not required.

Remember to refresh the data source when you re-try the formula.

Was this reply helpful? Yes No
ghostdragon 9 on at

Like
a
(0)

Report
Copy link

Link copied!
Got it.

Patch(Pool, Defaults(Pool), {Title: "New Session", Date: DatePicker1.SelectedDate})

Thanks for your help both

Was this reply helpful? Yes No