You’re offline. This is a read only version of the page.
Hello Power Users,
My challenge is, when I display a data table or gallery based on a SharePoint online list, Authors and Approvers (based on Draft Item Security choice) always see the latest version of the SharePoint List item, irrespective of the content approval status (which could be "Pending Approval" or "Rejected"), while the regular users always see the latest approved version.
Is it possible to fetch and display only the latest Approved version of each item for ALL users?
Hope my question is clear!
Hi @RDATTI ,
Have you enabled "Content Approval" option for your SP List?
Do you want to display the latest Approved version of each item for ALL users within your Gallery?
I have made a test on my side, please consider take a try with the following workaround:
Set the Items property of the Gallery to following:
Share
Report
All responses (
Answers (
Filter('20190816_case6', 'Content approval status' = "Approved")On your side, you may type:
Filter('Your SP List', 'Content approval status' = "Approved")Note: I assume that you have enabled "Content Approval" option for your SP List.
Above formula may cause a Delegation warning issue, if the amount of your SP List records is not more than 2000, you could ignore this warning issue.
If the amount of your SP List is more than 2000, you could consider bulk-load records from your SP List into a collection in your app, then use the collection as data source in your app instead of original SP List data source. Please check and see if the following threads would help in your scenario:
Best regards,
846
