Hello,
I am having a bit of an issue with an app I am building.
The way the app works is thus.
A user will create an idea and submit it to a sharepoint list, using the app.
The app will allow someone to go in and schedule that idea to be reviewed at a meeting.
The app will populate the agenda of the meeting and allow the idea to be updated and actions to be raised against that item, the actions are stored in a sharepoint list. These are then reviewed at the end of the meeting and then the updates get pushed back to the 2 separate sharepoint lists.
To assist with this I have set up a collection for Idea updates (colMeetingoutput) and a collection for the actions(colDTActions), with the actions capturing the ID of the Idea so they can be related to each other.
The issue I have is that in trying to patch the updates back to the sharepoint lists the below formula seems to be failing, although I get no error messages and from a formula perspective everything seems fine. The formula is against an On Select action of a button.
ForAll(
colDTActions,
Patch(
'Digital Triage Action tracker',
Defaults('Digital Triage Action tracker'),
{
Action: Action,
'Assigned to': Assignedto,
'Idea ID': IdeaID
}
)
);
ForAll(
colMeetingOutput,
Patch('Ideas PoC',
LookUp('Ideas PoC',ID=colMeetingOutput.ID),
{
'Assigned to': {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpanderUser",
Claims:" ",
Department:" ",
DisplayName: Assignedto,
Email: " ",
JobTitle:" ",
Picture:" "},
'Digital Triage Comments': DigitalTriageComments,
'Digital Triage Outcome': {Value:DigitalTriageOutcome},
Priority: {Value:Priority},
'Date For Review Technical Efficiency':DateForReviewTechnicalEfficiency,
Status:{Value:Status},
Title:Title
}
)
);
Clear(colMeetingOutput);
Clear(colDTActions)
I had this working with the first ForAll, but as soon as I added the 2nd one it stopped working (my assumption being that I cant do 2 ForAll actions). However not even the first For All action is working now.
Is anyone able to help me with this particular dilemma, please?
