Hi @v-jefferni,
Here it is, it is an initial formula without any changes:
UpdateContext({locBlockUserInput: true});
ClearCollect(
colQuestions,
AddColumns(
Filter(
'Employee Idea Questions',
'Employee Idea Questions'[@Campaign].'Employee Idea Campaign' = gblSelectedRecordCampaign.'Employee Idea Campaign'
),
//gblSelectedRecordCampaign.'Employee Idea Questions',
"appStringFields",
Concatenate(
Instructions,
Text(Sequence)
),
"appOptionSet",
'Response Type',
"appRef",
'Employee Idea Question',
"appRecordUpdated",
false
)
);
// Build Response Collection
Clear(colResponses);
Collect(
colResponses,
{
appRef: GUID(),
msft_name: "Title",
msft_snapshot_sequence: -2,
msft_employeeidea_responsetypecode: 'Employee Idea Response Type'.'Text (Single Line)',
msft_responsetext: Blank(),
msft_responserating: Blank(),
msft_snapshot_ratinghightext: "",
msft_snapshot_ratinglowtext: ""
},
{
appRef: GUID(),
msft_name: "Description",
msft_snapshot_sequence: -1,
msft_employeeidea_responsetypecode: 'Employee Idea Response Type'.'Text (Multiple Lines)',
msft_responsetext: Blank(),
msft_responserating: Blank(),
msft_snapshot_ratinghightext: "",
msft_snapshot_ratinglowtext: ""
}
);
ForAll(
colQuestions,
Collect(
colResponses,
{
appRef: GUID(),
msft_employeeidea_questionid: ThisRecord,
msft_name: ThisRecord.Instructions,
msft_snapshot_sequence: ThisRecord.Sequence,
msft_employeeidea_responsetypecode: ThisRecord.'Response Type',
msft_responsetext: Blank(),
msft_responserating: Blank(),
msft_snapshot_ratinghightext: ThisRecord.'Rating Text (High)',
msft_snapshot_ratinglowtext: ThisRecord.'Rating Text (Low)'
}
)
);
Clear(colFiles);
// Show/Hide
UpdateContext(
{
locVisibleCampaignCreate: false,
locVisibleCampaignEdit: false,
locVisibleCampaignIdea: true,
locVisibleCampaignView: false,
locCreateNewCampaign: false,
locCreateNewIdea: true,
locVisibleIdeaCommands: false
}
);
UpdateContext({locBlockUserInput: false});
In the meantime, I pasted the dropdown from the other screen to add the tag I intended. For this in data, added new column Status2 with 4 optional values: New, Approved, Not Approved, Implemented (scheme name: crdc9_Status2) in Employee ideas collection, similar to prioriziation toggler from the supporting guidelines. In items i put this formula: Choices('Status2 (Employee Ideas)'). Somehow the effect is the same: when I change the status in one idea, it is syncing with the rest. Attached the screenshot
