Answered

Mark Gallery Selected Item and Update Sharepoint list

(0) Share

Report

Posted on by jamescosten

643

I have a Gallery shwoing data from SP, with a field that says awaiting delivery. I would like to select the item in the gallery and update the SP list to show Delivered. I know i need to patch the SP list, but unsure on how to do this with Gallery Selected.

So when i Press the button at the top, any gellery item selected will have the Delivered filed altered from Awaiting Delivery to Delivered. This is a YES / NO Choice selection, with Delivered as TRUE.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

SebS 4,592 Moderator on at

Like (0)

Report

@jamescosten

Is the YES / NO Choice a Yes/No column or Choice column with Choice of Yes/No ?

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report

It is a Yes/No Column.

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (1)

Report

Hi @jamescosten ,
On Select property of the icon you can use something like below -
If(!IsBlank(GalleryName.Selected), Patch(SPListName, LookUp(SPListName, ID=GalleryName.Selected.ID, {YesNoTypeColumn: true}), Notify("No item in the gallery is selected", NotificationType.Error))
Considering Status is a choice column
In your form you can use -
If(ThisItem.YesNoTypeColumn, "Delivered", "Awaiting Delivery")

Was this reply helpful? Yes No
Verified answer

SebS 4,592 Moderator on at

Like (1)

Report
@jamescosten @NandiniBhagya20

Patch(SharepointList, Gallery1.Selected, { Delivery:true } )

You do not need to do any lookup Galler1.selected working with Patch and Patch recognise ID by it self

Was this reply helpful? Yes No