Editable grid for document library

(0) Share

Report

Posted on by da1ve

340

Hi all,

I was watching this video from Reza (https://www.youtube.com/watch?v=8I0Pt_8I6k8) but wondering if the same is possible with a document library as the source rather than a list or table?

When I am at the save edit part, my patch command is complaining about the data type (Invalid argument type (Table). Expecting a record value instead).

If(
 CountRows(colTaskUpdates) > 0,
 Patch(
 'Processes',
 colTaskUpdates
 );
Notify(
 "Success",
 NotificationType.Success
 )
);
Clear(colTaskUpdates);

Is it possible to have this functionality for a document library?

I am looking to manipulate the Status & Owner columns

Thanks,
David

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

WarrenBelz 153,127 Most Valuable Professional on at

Like (0)

Report
Hi @da1ve ,

You won't be able to do it just matching the collection, but assuming you have the ID of the Library item to be patched in the collection

If( CountRows(colTaskUpdates) > 0, Patch( 'Processes', ForAll( colTaskUpdates As aPatch, { ID: aPatch.ID, Status: aPatch.Status Owner: aPatch.Owner } ) ); Notify( "Success", NotificationType.Success ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report
@WarrenBelz ,

When you say ID of the library item - in my case is that "title" (which I renamed to "name")?

So the code would be:

If( CountRows(colTaskUpdates) > 0, Patch( 'Processes', ForAll( colTaskUpdates As aPatch, { Title: aPatch.Name, Status: aPatch.Status Owner: aPatch.Owner } ) ); Notify( "Success", NotificationType.Success ) );

Or have I got it completely wrong?

Was this reply helpful? Yes No