Delete rows by matching info in different columns

(0) Share

Report

Posted on by Dulat

102

Hi,

I am working on the app, substituting tabular document, and I am working on revision control logic.

Rev	Line Class	Item Code	Description	Size	RevStatus	PrevStatus	RowCount	OldRowCount
01	A	1111	aaaaaa	5	Published		1
01	A	1112	aaaaab	4	Published		2
01	A	1113	aaaaac	8	Published		3

So during editing stage, I am trying to keep both records: published and edited (need to reviewed before publishing).

At each step I am saving Previous status and tracking RowCount of original item to have mapping.

Rev	Line Class	Item Code	Description	Size	RevStatus	PrevStatus	RowCount	OldRowCount
01	A	1111	aaaaaa	5	Published		1
01	A	1112	aaaaab	4	Published		2
01	A	1113	aaaaac	8	Published		3
01	A	1112	aaaaab	3	Edited	Published	4	2
01	A	1113	aaaaac	6	Edited	Published	5	3

Once Lead has reviewed edition, Rev Status.

Rev	Line Class	Item Code	Description	Size	RevStatus	PrevStatus	RowCount	OldRowCount
01	A	1111	aaaaaa	5	Published		1
01	A	1112	aaaaab	4	Published		2
01	A	1113	aaaaac	8	Published		3
01	A	1112	aaaaab	3	Approved	Edited	4	2
01	A	1113	aaaaac	6	Approved	Edited	5	3

I have completed these steps, using patch function on selected row from the Gallery.

However, I am struggling with last operation, since document is big we need to make in bulk.

We need to do two thing at the same time:

1. Convert Approved/Edited items to Published status - no problem there.

2. Convert Published obsolete items to Deleted status, using information in RowCount and OldRowCount columns. - I am struggling with this.

Can someone help me with this?

Rev	Line Class	Item Code	Description	Size	RevStatus	PrevStatus	RowCount	OldRowCount
01	A	1111	aaaaaa	5	Published		1
02	A	1112	aaaaab	4	Deleted		2
02	A	1113	aaaaac	8	Deleted		3
02	A	1112	aaaaab	3	Published		4	2
02	A	1113	aaaaac	6	Published		5	3

If that make difference, at the moment, my data types for columns are following.

Rev	Line Class	Item Code	Description	Size	RevStatus	PrevStatus	RowCount	OldRowCount
Text	Text	Text	Text	Num	Text	Text	Num	Num

Thanks

Dulat

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

SebS 4,584 Moderator on at

Like (0)

Report
@Dulat

Could you try to use RemoveIf() ?

RemoveIf( YourDataSource, RevStatus = "Published" && RowCount <= OldRowCount )

I'm not sure if I got it right, but have a look.

Was this reply helpful? Yes No
Dulat 102 on at

Like (0)

Report

I don't want to remove it from the data source. I want to just change status to Deleted, so users (not admins) do not see it, but it is in the data source for the future information for admins.

Was this reply helpful? Yes No
SebS 4,584 Moderator on at

Like (0)

Report
@Dulat

In that case you can try

UpdateIf( YourDataSource, RevStatus = "Published" && RowCount <= OldRowCount, { RevStatus: "Deleted" } )

Was this reply helpful? Yes No
Dulat 102 on at

Like (0)

Report

@SebS

Thanks for help!
During revision, edited items may be rejected. RevStatus "Rejected" and PrevStatus "Edited".
Thus, I want to make sure I am "deleting" only items, which have mapped pair with RevStatus "Approved" and PrevStatus "Edited".
Basically if item has RevStatus = "Approved" and PrevStatus = "Edited" and OldRowCount=2,
I will find item with RowCount=2 and mark its RevStatus as "Deleted".

Something like join operation in SQL or Pandas to filter tables two tables (here same copy of one).

Thanks

Was this reply helpful? Yes No
Verified answer

Dulat 102 on at

Like (1)

Report
ClearCollect( col_publish_delete_edited, Filter( GalleryPubli**bleep**ems.AllItems, RevisionStatus = "Endorsed" && PrevStatus = "Edited" && OldRowCount <> 0 ) ); ForAll( RenameColumns( col_publish_delete_edited, "OldRowCount", "OldRowCount1" ), If( !IsBlankOrError( Patch( datasource, LookUp( datasource, RowCount = OldRowCount1 ), { REV: RevisionInput.Text, Comments: CommentPublish.Text, RevisionStatus: "Deleted", PrevStatus: "", PublishedBy: User().FullName, Published: Now() } ) ), Patch( col_main_table, LookUp( col_main_table, RowCount = OldRowCount1 ), { REV: RevisionInput.Text, Comments: CommentPublish.Text, RevisionStatus: "Deleted", PrevStatus: "", PublishedBy: User().FullName, Published: Now() } ), Notify( "Data was not written to the source", NotificationType.Error ) ) )
@SebS

Was this reply helpful? Yes No