Hi Team,
I am struggling with Patch and Couple of Formula.
The formula I need is WeekNumber and Month Name for which I have DatePicker Name as PKTDate as Reference.
Month Name is a TextInput Called TextInputMonth
WeekNumber as TextInputWeekNumber
These Two Inputs need to auto Populated, the moment user select Date from DatePicker.
I have 6 fields that are not a part of the gallery. I want to submit 11 Feild to SharePoint List (ProcessKnowledgeTest)
Out of 6 Fields which I have added 1 DatePicker, 4 InputBox, 1 Dropdown.
Im not sure what you want to do;
If it is you want to modify multiple records...UpdateIf()
Wants to update the entire Gallery
Whereas, It is updating only one single rows
Patch(
ProcessKnowledgeTest,Defaults(ProcessKnowledgeTest),
{PKTDate:PKTDate.SelectedDate,Week_Number:PKTWeek.Text,Month:PKTMonth.Text,LOB:LineOfBusiness.Text,QueueName:DropdownQueue.Selected.queue_name,SAPID:SAPID.Text,EID:EID.Text,OpportunityEarned:TextInputOpportunityEarned.Text,TotalOpportunity:TextInputTotalOpportunity.Text,UploadedBy:UploadeBY.Text}
)
What am I missing guys ?
Hi TJO,
How about the Patch function. Where am I wrong. Please correct me on the below formula
Patch(
ProcessKnowledgeTest,
ProcessKnowledgeTestGallery.Selected,
{PKTDate:PKTDate.SelectedDate,Week_Number:PKTWeek.Text,Month:PKTMonth.Text,LOB:LineOfBusiness.Text,QueueName:DropdownQueue.Selected.queue_name,SAPID:SAPID.Text,EID:EID.Text,OpportunityEarned:TextInputOpportunityEarned.Text,TotalOpportunity:TextInputTotalOpportunity.Text,UploadedBy:UploadeBY.Text}
);
@akbarmahfuzalam: Here's some input that might help; try putting that into the respective 'Text' properties:
For the Weeknumber (Week starting from Monday) into 'Text' of TextInputWeekNumber:
If(
RoundDown(
(PKTDate.SelectedDate - Date(
Year(PKTDate.SelectedDate),
1,
1
) + (Weekday(
Date(
Year(PKTDate.SelectedDate),
1,
1
) - 1,
Monday
))) / 7,
0
) = 0,
52,
RoundDown(
(PKTDate.SelectedDate - Date(
Year(PKTDate.SelectedDate),
1,
1
) + (Weekday(
Date(
Year(PKTDate.SelectedDate),
1,
1
) - 1,
Monday
))) / 7,
0
)
)
And for the month I'm not so sure; maybe something like this (mm for months number, and mmm or mmmm for verbose, not sure which one)
Text(Month(PKTDate.SelectedDate), "[$-de-DE]mm")
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2