Patch multiple items in a gallery at one button click power apps

(0) Share

Report

Posted on by KrishR

431

Hello Power Users,

I have a gallery in a power app that displays the items with status in progress and would like to have a button outside the gallery. Button on click should approve all the items displayed in the gallery. Found lot of solutions in the community but for some reasons it still throws error. Here's my code

ForAll(Gallery.AllItems, Patch(TableName, {ReqStatus : "Approve"}))

When I hover on the table name it says "Invalid argument type (Guid). Expecting a Table value instead"

When I hover on the column name, reqStatus says "The specified column 'ReqStatus' does not exist"

ReqStatus column is single line of text on data verse table.

Can anyone please help me if anything wrong in my code.

Thank you for your help in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!
@KrishR

You could try Patch( ForAll()) instead

Patch( TableName, ForAll( Gallery.AllItems As _myPatch, { ID: _myPatch.ID, ReqStatus : "Approve" // If ReqStatus column is a Choice type, try this // ReqStatus : {Value: "Approve"} } ) )

Change .ID to the relevant DataVerse record reference. The .ID is a SharePoint reference. I don't work with DV so you will likely need to adjust that part.

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @KrishR ,
ForAll(Gallery.AllItems as G, Patch(TableName,LookUp(TableName,Name = G.Name),{ReqStatus : "Approve"}))

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report
Copy link

Link copied!
Hi @EddieE ,

Thanks for your time and help.

Can you please help me with what should my code go in place or "_myPatch" from
ForAll( Gallery.AllItems As _myPatch, { ID: _myPatch.ID,
Can you please help me understand.

Thanks again!

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@KrishR

There's no need to change that - it's just a reference you use in your code, it doesn't reference any of your data sources.

As usage

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report
Copy link

Link copied!

Hi @EddieE ,

Thanks for the explanation. I tried the formulae and on click of the button it started creating new items instead of updating the items present in the gallery. Do we have to add a lookup or filter the gallery to choose the items to update.

In my case I had the gallery to show the items whose status are empty or rejected. And update all of them with status value as Approved.

Thank you so much again!

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@KrishR

What is the Items property of the gallery? Does it contain the ID (or equivalent in DataVerse) ?

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report
Copy link

Link copied!

@EddieE
It doesn't have any id I'm referring to.
Item property of the gallery :

Filter(TableName, Status <>"Completed" && Status <> "Denied")
Thank you

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@KrishR

Ok, then what is the 'Primary Key' / record identifier for your records, ie what is that field called?

You couldn't do a LookUp or Filter without some sort of record reference.

The way the ID works in my formula above is that it resolves the ID for you. For example, if you are patching New records then there will be no ID present, so the formula will know to create a New record. However, if there is an ID present (ie an existing record) then the Patch knows to Update instead. It's quite clever.

Was this reply helpful? Yes No
KrishR 431 on at

Like (0)

Report
Copy link

Link copied!

@EddieE ,

I have Name column as Primary name column. How do I filter on that column?

Thank you!

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!
@KrishR

Try replacing ID with Name, ie

Patch( TableName, ForAll( Gallery.AllItems As _myPatch, { Name: _myPatch.Name, ReqStatus : "Approve" // If ReqStatus column is a Choice type, try this // ReqStatus : {Value: "Approve"} } ) )

Was this reply helpful? Yes No