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

[jaanihsm]

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!

[WarrenBelz]

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

[jaanihsm]

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

[WarrenBelz · Accepted solution]

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

[jaanihsm]

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. 😊🙌