Hello @WarrenBelz , thank you for your response. I figured out a few bits. Here is the whole correct code looks like !!!
Below are the columns in Collections
- RACIDescription ---------------- Column Type Text
- RACIDeadline ------------------- Column Type Choice
- RACIStatus ---------------------- Column Type Choice
- ScopeRAG ---------------------- Column Type Choice
- ScheduleRAG ------------------- Column Type Choice
- ResourceRAG ------------------- Column Type Choice
- RAIDRAG ----------------------- Column Type Choice
- ChangeMgtRAG ---------------- Column Type Choice
Below are the columns in SharePoint
- RACI Description ------------------- Column Type Text
- RACI Deadline ---------------------- Column Type Choice
- RACI Status ------------------------- Column Type Choice
- Scope RAG -------------------------- Column Type Choice
- Schedule RAG ---------------------- Column Type Choice
- Resource RAG ---------------------- Column Type Choice
- RAID RAG --------------------------- Column Type Choice
- Change Mgt RAG ------------------- Column Type Choice
OnStart of the App
ClearCollect(
col_RACI_Objectives,
ShowColumns(
Table(Defaults('RACI Objectives')),
"ID",
"RACIDescription",
{ "RACIDeadline", Text }, // Text data type (for Choice)
{ "RACIStatus", Text }, // Text data type (for Choice)
{ "ScopeRAG", Text }, // Text data type (for Choice)
{ "ScheduleRAG", Text }, // Text data type (for Choice)
{ "ResourceRAG", Text }, // Text data type (for Choice)
{ "RAIDRAG", Text }, // Text data type (for Choice)
{ "ChangeMgtRAG", Text } // Text data type (for Choice)
)
);
Clear(col_RACI_Objectives);
OnChange of all these input controls
If(
ThisItem.ID in col_RACI_Objectives.ID,
Update(
col_RACI_Objectives,
LookUp(
col_RACI_Objectives,
ID = ThisItem.ID
),
{
ID: ThisItem.ID,
RACIDescription: Gallery_RACI_Description_Input.Text,
RACIDeadline: Gallery_RACI_Deadline_Input.Selected.Value,
RACIStatus: Gallery_RACI_Status_Input.Selected.Value,
ScopeRAG: Gallery_Scope_RAG_Input.Selected.Value,
ScheduleRAG: Gallery_Schedule_RAG_Input.Selected.Value,
ResourceRAG: Gallery_Resource_RAG_Input.Selected.Value,
RAIDRAG: Gallery_RAID_RAG_Input.Selected.Value,
ChangeMgtRAG: Gallery_Change_Mgt_RAG_Input.Selected.Value
}
),
Collect(
col_RACI_Objectives,
{
ID: ThisItem.ID,
RACIDescription: Gallery_RACI_Description_Input.Text,
RACIDeadline: Gallery_RACI_Deadline_Input.Selected.Value,
RACIStatus: Gallery_RACI_Status_Input.Selected.Value,
ScopeRAG: Gallery_Scope_RAG_Input.Selected.Value,
ScheduleRAG: Gallery_Schedule_RAG_Input.Selected.Value,
ResourceRAG: Gallery_Resource_RAG_Input.Selected.Value,
RAIDRAG: Gallery_RAID_RAG_Input.Selected.Value,
ChangeMgtRAG: Gallery_Change_Mgt_RAG_Input.Selected.Value
}
)
)
OnSelect of "New RACI objective" Button
Patch(
'RACI Objectives',
Defaults('RACI Objectives'),
{'Project Name': ""}
)
OnSelect of "Save" Button
If(
CountRows(col_RACI_Objectives) > 0,
ForAll(
col_RACI_Objectives,
Patch(
'RACI Objectives',
LookUp('RACI Objectives', ID = col_RACI_Objectives[@ID]),
{
'RACI Description': col_RACI_Objectives[@RACIDescription],
'RACI Deadline': {Value: col_RACI_Objectives[@RACIDeadline]},
'RACI Status': {Value: col_RACI_Objectives[@RACIStatus]},
'Scope RAG': {Value: col_RACI_Objectives[@ScopeRAG]},
'Schedule RAG': {Value: col_RACI_Objectives[@ScheduleRAG]},
'Resource RAG': {Value: col_RACI_Objectives[@ResourceRAG]},
'RAID RAG': {Value: col_RACI_Objectives[@RAIDRAG]},
'Change Mgt RAG': {Value: col_RACI_Objectives[@ChangeMgtRAG]}
}
)
);
Notify(
"No saved Data to patch",
NotificationType.Information
)
);
Clear(col_RACI_Objectives);
