I am currently working on an app where mulitple users will be submitting forms that write back to SP. I currently have a gallery that shows all the forms that were created and can be edited through the gallery. Currently it is showing all the forms created. How do i make it so that it just displays the forms of whoever is logged into the app?
The app linked thorugh O365
Please let me know if you have any addtional questions.
Solved! Go to Solution.
On App Load, create a variable to store the current user email or object
For gallery use filter function on Items property
Filter(DataSource, 'Created By'.Email = varCurrentUserEmail)
Plz note :- this would give you a delegation warning because Created By is a person or group type column which is a complex column (delegation will return upto 2000 records only)
In order to avoid delegation, create another column called "CreatedByText" and store the created by users email in there
then you could use
Filter(DataSource, CreatedByText = varCurrentUserEmail) which would avid the delegation warning
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights