Filter a gallery based on user's actions (either Approved or Rejected items) in Approvals

(0) Share

Report

Posted on by jaanihsm

300

Hi! I have a gallery and I only want to show the 'Approved' and 'Rejected' items of the current user from Approvals.

So basically any item that the user has already actioned from Approvals.

Any recommendations on how to do it? Thank you so much!

In my SharePoint list I have an 'Approval History' column that is formatted as below:

SIGNED by: User

REJECTED by: User

If 'Joh' has already actioned this item, on her gallery view, she should see this item.

Please let me know if you need more details. Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @jaanihsm ,

It would be far easier to have a Status column with either Approved or Rejected and then the filter would be Delegable, however assuming that your 'Approval History' column is a Single Line of Text and that the first word is either Approved or Rejected then

Filter( YourSPList, StartsWith( 'Approval History', "Approved" ) || StartsWith( 'Approval History', "Rejected" ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report

Thanks for the response @WarrenBelz!
This is a multi-line text column though...any other recommendations other than creating an additional column for the status? Would concatenate work? If yes could you kindly walk me through it?

This is a sample of the Approval History in text:

----------------------------------------------------------
🟢 SIGNED by: User1's Full Name
Comments (if any): Good to go
----------------------------------------------------------
🟢 SIGNED by: User2's FullName
Comments (if any): Approve

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi @jaanihsm ,

Not in any Delegable way. A status column would allow a Delegable query based on one of the required values being equal to it. If you want to search the latest Data Row Limit (500-2,000) records

With( { _Data: Sort( YourSPList, ID, SortOrder.Descending ) }, Filter( _Data, "Approved" in 'Approval History' || "Rejected" in 'Approval History' ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report

This did the trick! 🎉
Thanks for the heads up about delegation! My list should not exceed 2000 items though so should be okay.

Thank you so much @WarrenBelz!
Greatly appreciate your time and knowledge-sharing. 😊🙌

Was this reply helpful? Yes No