Sharepoint list retrieve people as default value from previous row

[ML_1982]

Hi,
I am trying to use a Sharepoint list as a meeting protocol. A new entry is to be created for each agenda item. The moderator of the meeting should not always have to re-enter all participants. It would therefore be useful if the participants of the last entry were used as the default value for new entries. I have already tried it with a power app form, but I can't get any further. Any help is appreciated!

[KeithAtherton]

Hi @ML_1982,

Do you save the selected participants in a collection using the ClearCollect() method then use them as defaults when setting up a new entry?

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Connect with me online.

[ML_1982]

Hi Keith,
ClearCollect() has actually got me a bit further now. I actually didn't know the method before. In connection with the default properties of the form field, however, I still seem to be using it incorrectly. The error is saying: The expression was intended to filter the 'Meeting Minutes CMS' table based on the last ID value and then collect the 'Participants' column into the 'colPart' collection. However, the error indicates that a behavior function (ClearCollect) is being used in a non-behavior property, which is not allowed. I guess it's obvious that I'm a total newbie. 

Thanks in advance for your help.

[KeithAtherton]

You're welcome. We all started somewhere, sounds like you're learning a lot 🙂

Can you send screenshots of the code and where you're seeing the error message please?

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Connect with me online.

[ML_1982]

Sure. I hope that explain enough. I assume that the problem is that I have placed the formula in the default field, but there is no trigger for creating the collection. But IDK.

[KeithAtherton]

Thanks. So, I believe the error is showing because the code uses the ClearCollect() function to build a collection called colPart.

However, we can actually simplify the code to just return the collection rather than save it as a new collection by doing the following:

Filter('Meeting Minutes CMS', ID = Last('Meeting Minutes CMS').ID).Participants

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Connect with me online.

[ML_1982]

It no longer shows an error, but as soon as I publish it and return to the Sharepoint list and want to create a new entry with the form, the field is empty and no default value is set.