Answered

Update sharepoint list from Collection

(1) Share

Report

Posted on by Jens Seiger

I have created an powerapp where I use the SharePoint List ID as a data entry to a collection - Based on that I would like to submit the collections by ID and update a text field to a constant "Delivered" - but nothing gets updated. Any help would be great.

Entry field "Type=Number"

OnChange: Collect(ScanDel, {ID: Deliver.Text, Status_Txt: "Delivered"}); Reset(Deliver)

Submit: ForAll(ScanDel, Patch('SHPLIST', First(Filter('SHPLIST', ID = ScanDel.ID)) , {Status_Txt:"Delivered"}))

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JensSeiger,
Your patch function syntax looks correct. You would put it as the OnSelect property of an icon or button to run it.

Was this reply helpful? Yes No
Jens Seiger 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your fast reply. The Submit is a butron and unfortunately not working. Any ideas? Any difference as I am using the ID?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I wouldn’t think so. To find out where the problem is, test it without the ForAll. BTW, Is the delivered field a Choice or Lookup type column in your SharePoint list?

Was this reply helpful? Yes No
Jens Seiger 17 on at

Like
a
(0)

Report
Copy link

Link copied!

No. It is a single line.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@JensSeiger
The problem could be ID. You may want to try using the disambiguation operator
ForAll(ScanDel, Patch('SHPLIST', First(Filter('SHPLIST', ID = ScanDel[@ID])) , {Status_Txt:"Delivered"})). If that works, please mark the discussion solved.

Was this reply helpful? Yes No
Verified answer

Jens Seiger 17 on at

Like
a
(1)

Report
Copy link

Link copied!

I figured it out. I needed to call the value of the field in the collection. My warning showed me that I can't compare text with a value.
That means I changed the collect to:

Collect(ScanDel, {ID: Value(Deliver.Text), Status_Txt: "Delivered"}); Reset(Deliver)

Was this reply helpful? Yes No
simon0275 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for this fixed my issue. disambiguation operator.

Was this reply helpful? Yes No