cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AdrianMitroiu
Helper I
Helper I

Patch Collection makes Edit Form unavailable

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-sheyu-msft
Community Support
Community Support

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

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-sheyu-msft
Community Support
Community Support

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

Community Support Team _ Eason YU
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,014)