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:
Before I add the "Status" column in the collection, Edit form worked as it should.
What am I missing?
Solved! Go to Solution.
Hi @AdrianMitroiu,
The error message is caused by that when the field property in the Edit Form doesn’t match to the structure of the DataSource.
I assume that there’s a ID column in your collection
You can try to set Items property of EditForm to :
LookUp(QuestionnairesList,BrowseGallery1.Selected.ID=ID)
Regards,
Eason
Hi @AdrianMitroiu,
The error message is caused by that when the field property in the Edit Form doesn’t match to the structure of the DataSource.
I assume that there’s a ID column in your collection
You can try to set Items property of EditForm to :
LookUp(QuestionnairesList,BrowseGallery1.Selected.ID=ID)
Regards,
Eason
Thank you for your reply @v-sheyu-msft,
Your solution, as far as I have tried, works.
Meanwhile I have created a second collection where I have stored the ID from the QuestionnairesList and the Status that it gets after my condition.
However i have to agree that your solution is clearer.
Thank you for your time.
Adrian.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
190 | |
95 | |
65 | |
63 | |
58 |
User | Count |
---|---|
243 | |
163 | |
91 | |
79 | |
79 |