I have a gallery with checkboxes. The gallery uses data from sharepoint.
If a checkbox is marked and I click on a button the marked items in sharepoint shall be patched (column "Send" shall be set to "true").
I tried the following code, but the sharepoint list is not patched.
ForAll(Filter(Gallery.AllItems; CheckboxAuswählen.Value = true); Collect(MarkedItems; {string:Titel});;
Patch(SharepointList; LookUp(SharepointList; Titel= First(MarkedItems).string); {Send: true});;
Remove(MarkedItems;First(test)));;
Thanks a lot!
Solved! Go to Solution.
If the items property of your gallery directly has your sharepoint list as a source, you can just use "ThisRecord" Instead of the lookUp
Something like:
ForAll(
Filter(
Gallery.AllItems;
CheckboxAuswählen.Value=true
);
Patch(
SharePointList;
ThisRecord;
{
Send: true
}
)
)
Please check syntax i freehanded
Check https://youtu.be/VzrarcM9W5k
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Thanks,
Reza Dorrani, MVP
YouTube
Twitter
Hi @RezaDorrani I watched some parts of your videos, but I am not sure if they can help me in this concrete case...will probably have to watch them in full.
I replaced "Titel= First(MarkedItems).string" with "Titel = ExistingTitle" and the sharepoint entry with the existing title got patched....
therefore I assume that "Titel= First(MarkedItems).string" is not working as expected.
Why is that the case?
Why is that the case?
I can stil not figure it out...the video has a lots of interesting informations @RezaDorrani but I do not see how it helps me solve my problem.
Could you please tell me in which part of the video you think is the solution -
or directly explain to me how I can solve this.
Thanks a lot in advance!
If the items property of your gallery directly has your sharepoint list as a source, you can just use "ThisRecord" Instead of the lookUp
Something like:
ForAll(
Filter(
Gallery.AllItems;
CheckboxAuswählen.Value=true
);
Patch(
SharePointList;
ThisRecord;
{
Send: true
}
)
)
Please check syntax i freehanded
This was exactly the solution I've been searching for hours to find!
I hope others find this solution when you cannot match an ID in a collection with an ID in a SharePoint list. Above is what helped me with my patch to update a SharePoint list with a collection's data.
User | Count |
---|---|
254 | |
112 | |
92 | |
48 | |
38 |