Patch the selected row only in gallery

(0) Share

Report

Posted on by Powerappsuser11

237

Hi Community Team,

I Created canvas for timesheet .Datasource is sharepoint list.

Created collectin for add a new row in gallery.

My requirement is when user select save button that particular row only saved in sharepoint list.

Gallery contains-Date:Datepicker,Dropdown:Project,Dropdown:Task,Dropdown:Type,Hour:Text Input,Comment:Text input.

Note:Project and Task are lookup column in shareppoint list.

Below Project Dropdown--Project

TaskDropdown--Task

Kindly provide code for onselect of save button.

Thanks in advance for quick response.....!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Fardy_MADI_2 332 Super User 2024 Season 1 on at

Like (0)

Report
Hi @Powerappsuser11,

Try this formula :
Patch(DateSource, ThisItem,
{Date : ThisItem.Date.SelectedDate,
Project : ThisItem.Project.SelectedText.Value,
Task : ThisItem.Task.SelectedText.Value,
Type : ThisItem.Type.SelectedText.Value,
Hour : ThisItem.Hour.Text,
Comment : ThisItemComment.Text}
)

If Hour is a number type in your sharepoint list then the formula is Value(ThisItem.Hour.Text)

Hope this will help you 🙂

Was this reply helpful? Yes No
akselmb 65 on at

Like (1)

Report
Hi @Powerappsuser11

Try this on the OnSelect-property for the Save-button:

Patch( SPDataSourceName, Defaults(SPDataSourceName), { Date: ThisItem.Date.SelectedDate, Project: LookUp(SPProjectsList, ProjectName = ThisItem.Project).ID, Task: LookUp(SPTasksList, TaskName = ThisItem.Task).ID, Type: ThisItem.Type.SelectedItem, Hour: Value(ThisItem.Hour.Text), Comment: ThisItem.Comment.Text } )

Change SPDataSourceName with the name of your datasource. Same goes with SPProjectList and SPTaskList

Let me know how it goes 🙂

Was this reply helpful? Yes No
Powerappsuser11 237 on at

Like (0)

Report

Hi @Fardy1 ,

Above code written but getting errors,
Please help me.
Patch('Time sheet',ThisItem,
{
Title:User().FullName,Email:User().Email,status:{Value:"Draft"},
Description:TextInput7_1.Text,
Hour:Value(TextInput7.Text),
'Date and Time':DatePicker6.SelectedDate,
'Extended Hour':Value(TextInput10.Text),
Project:Dropdown10.SelectedText.Value,
'Project Line':Dropdown11.SelectedText.Value,
'Hours Type':Dropdown12.Selected,
}))

Was this reply helpful? Yes No
akselmb 65 on at

Like (0)

Report
Based on the error-message that you got, try this instead for your line related to project:
Project: LookUp(SPProjectsList, ProjectName = ThisItem.Project.Value).ID

Was this reply helpful? Yes No
Powerappsuser11 237 on at

Like (0)

Report

Hi @akselmb

Thanks for quick respond.
I applied save button in gallery control,user select a row that row only saved in sharepoint.
below is my code but getting errors,plese help to resolve this issues.
Patch('Time sheet',ThisItem,
{
Title:User().FullName,Email:User().Email,status:{Value:"Draft"},
Description:TextInput7_1.Text,
Hour:Value(TextInput7.Text),
'Date and Time':DatePicker6.SelectedDate,
'Extended Hour':Value(TextInput10.Text),
Project:LookUp('Time sheet',Project=ThisItem.Project.Value).ID,
'Project Line':LookUp('Time sheet','Project Line' =ThisItem.Task.Value).ID,
'Hours Type':Dropdown12.Selected,
}))

Was this reply helpful? Yes No
Fardy_MADI_2 332 Super User 2024 Season 1 on at

Like (0)

Report

According to this error, it seems that your Project column in your sharepoint list is a number type.

Was this reply helpful? Yes No
Powerappsuser11 237 on at

Like (0)

Report

Hi @Fardy1

Those are in lookup columns only.

Was this reply helpful? Yes No
akselmb 65 on at

Like (0)

Report
My bad, @Powerappsuser11 . Try removing ".ID" after the LookUp-function. The error message is saying that it is excepting a record and by adding ".ID" we are giving it the records ID instead of the whole record. Same goes for the similar lines.
Project: LookUp(SPProjectsList, ProjectName = ThisItem.Project.Value)

Was this reply helpful? Yes No