cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JensVolswinkler
Regular Visitor

Patch Sharepoint list when a gallery item is marked does not work

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!

1 ACCEPTED SOLUTION

Accepted Solutions
KvB1
Solution Specialist
Solution Specialist

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

View solution in original post

4 REPLIES 4
RezaDorrani
Dual Super User II
Dual Super User II

Hi @JensVolswinkler 

 

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

JensVolswinkler
Regular Visitor

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?

JensVolswinkler
Regular Visitor

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!

KvB1
Solution Specialist
Solution Specialist

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

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,116)