cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

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

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,945)