Update the status of all items in gallery

Like (0) Share

Report

Posted on 10 Jul 2023 06:09:43 by jco0

Hi, I want to update all the items in my gallery, but i have some error that i cannot fix it.

GalleryName: GalleryApproval

DataSource:Dataverse

Columnt Type: travel Status is a choice column

ForAll(
 GalleryApproval.AllItems,
 Patch(
 HR_Travel_Request_Monitoring,
 LookUp(HR_Travel_Request_Monitoring, ID = GalleryApproval.Selected.ID),
 { 'Travel Status': {Value: "Completed"}}
 )
)

Categories:

Using Apps Using Formulas

General Questions

Connecting to Data

All responses (14)

Answers (1)

jco0 29 on 10 Jul 2023 at 09:21:04

Like (0)

Report

Re: Update the status of all items in gallery

It Worked. Thank you @v-mingkz-msft
Verified answer

v-mingkz-msft Microsoft Employee on 10 Jul 2023 at 09:16:55

Like (1)

Report
Re: Update the status of all items in gallery

Hi @jco0,
ForAll( GalleryApproval.AllItems As AllItems, Patch( [@'HR_Travel_Request_Monitoring'], LookUp([@'HR_Travel_Request_Monitoring'], ID = AllItems.ID), {'Travel Status':"Completed"} ) )

Best Regards,
Kyrie
jco0 29 on 10 Jul 2023 at 08:35:31

Like (0)

Report

Re: Update the status of all items in gallery

Hi @v-mingkz-msft ,

i tried your solutions, but nothing happened after i try your code.

thank you
v-mingkz-msft Microsoft Employee on 10 Jul 2023 at 08:15:39

Like (0)

Report
Re: Update the status of all items in gallery

Please try:
ForAll( GalleryApproval.AllItems, Patch( [@'HR_Travel_Request_Monitoring'], LookUp([@'HR_Travel_Request_Monitoring'], ID = ThisRecord.ID), {'Travel Status':"Completed"} ) )
jco0 29 on 10 Jul 2023 at 07:52:23

Like (0)

Report

Re: Update the status of all items in gallery

it just updated the selected item not all the items in gallery
v-mingkz-msft Microsoft Employee on 10 Jul 2023 at 07:44:57

Like (0)

Report
Re: Update the status of all items in gallery

Hi @jco0,
Please try:
ForAll( GalleryApproval.AllItems, Patch( [@'HR_Travel_Request_Monitoring'], LookUp([@'HR_Travel_Request_Monitoring'], ID = GalleryApproval.Selected.ID), {'Travel Status':"Completed"} ) )

Best Regards,
Kyrie
jco0 29 on 10 Jul 2023 at 07:21:35

Like (0)

Report

Re: Update the status of all items in gallery

i just want to update the items inside of the gallery
v-mingkz-msft Microsoft Employee on 10 Jul 2023 at 07:03:15

Like (0)

Report
Re: Update the status of all items in gallery

Hi @jco0,
Do you want to update all items in Dataverse table?
Please try:
UpdateIf('HR_Travel_Request_Monitoring',true,{'Travel Status':"Completed"})

Best Regards,
Kyrie
jco0 29 on 10 Jul 2023 at 06:39:01

Like (0)

Report

Re: Update the status of all items in gallery

Detailed error information
jco0 29 on 10 Jul 2023 at 06:36:37

Like (0)

Report

Re: Update the status of all items in gallery

still the same 😞