cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
Community Support
Community Support

Re: Patch Collection makes Edit Form unavailable

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
Highlighted
Community Support
Community Support

Re: Patch Collection makes Edit Form unavailable

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

Highlighted
Helper I
Helper I

Re: Patch Collection makes Edit Form unavailable

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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,633)