Hi there,
I have created an app based on a SP List as a questionnaire.
Based on the user answers I marked the questionnaire as 'Completed' or 'Incompleted' using the "Patch" function to update a column in collection that is not in the SP List.
Collect(
QuestionnairesList,
{
Status: "",
...
}
);
If(_condition_,
Patch(
QuestionnairesList,
First(
Filter(
QuestionnairesList,
Title = AddTitleInput.Text
)
),
{Status: "Incomplet"}
),
Patch(
QuestionnairesList,
First(
Filter(
QuestionnairesList,
Title = AddTitleInput.Text
)
),
{Status: "Complet"}
)
)
My problem is that when I Edit the questionnaire the "Item" property of the form shows the Error: "Invalid formula. Expected a value compatible with 'DataSource'."
I should mention that:
- the Gallery Items is 'QuestionnairesList' collection
- the EditForm Item is 'Questionnaires.Selected' ( Questionnares is the name of the Gallery)
- the EditForm DataSource is 'QuestionnairesList'
Before I add the "Status" column in the collection, Edit form worked as it should.
What am I missing?