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.

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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,070)