Share
Report
20Hello,
I have a SharePoint list (Documents) that contains a list of documents. Each row is a document with various pieces of information. With the help of a PowerApp, users should be able to view and "subscribe" to the documents. In the app, I have implemented a gallery through which users can view the information of the documents. Documents can be selected via checkboxes.
A Power Automate Flow is supposed to be triggered by changes to the document list. It should check which users have subscribed to which documents and notify them accordingly. My idea is to do this with the help of a second list ("Subscriptions") In this second list, I have the columns "User" and "Documents". The "Documents" column is a lookup column that has stored the document titles of the first list as values (Multi-Selection field). So, one row could contain the user "Michael Miller" and "Document A, Document B".
When clicking the checkbox of an item in the gallery, the item is written into a collection:
- OnCheck: Collect(SelectedDocuments, ThisItem.'Document Name')
- OnUncheck: Remove(SelectedDocuments,LookUp(SelectedDocuments, Value=ThisItem.'Document Name'))
I am failing to write all values of the collection into a multi-selection field in a row of the list.
My first approach was to set up an invisible form that contains all values of the collection (= all selected items) in the "Documents" field as "DefaultSelectedItems". The values where listed in the form, but when submitting the form, these values were not written into the SP list.
Any help or suggestions would be greatly appreciated.
Thank you in advance!
All responses (
Answers (
