Gallery filter formula to filer by user and sort by created on

(0) Share

Report

Posted on by vinmam123

Hi All,

Working on my first powerapp project! Learning through this community is great from past two weeks!

I have created power app form based on SharePoint list.

User can access it through link. No Login required

Want to give option where user can access the app after somedays to see what he/she has submitted

To do so I have created a gallery linking to SharePoint data source(linking SharePoint list).

I want to filer gallery based on current user and last record submitted

Thanks in advance!

Regards,

Vinmam123

Regards,

Vinayak

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @vinmam123 ,

This should get the last record in thr gallery submitted by the current user, assuming the gallery contains the relevant fields.

LookUp( Sort( GalleryName.AllItems, Modified, Descending ), 'Created By'.Email = User().Email )

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.

Visit my blog Practical Power Apps
vinmam123 89 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick response!
Do I have to apply it on gallery and item property should be "Item".Hope my understanding is correct?
Sorry if it is silly question
Regards,
Vinayak
WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vinmam123 ,

No - it would be the Text of a Label, the Default of a Text Box or you might be setting a Variable to the value as the output is Text.

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.

Visit my blog Practical Power Apps
vinmam123 89 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @WarrenBelz ,
Hi,
Thanks for the response:!
Please refer the below screenshot:
Gallery (Highlighted in red) I have linked to SharePoint list source
I created the display form(Highlighted in green) from same SharePoint list
I Linked Display form(Highlighted in green) to Galleryname.selected
I can find the last submit record in the form (The formula used for this is highlighted in blue)
Now I want formula to filter by current user email so that display form will display only current user last submitted data
Can you please help me to tweak the formula(Highlighted in blue to achieve this)
Screenshot:
Regards,
Vinayak
WarrenBelz 156,714 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @vinmam123 .

Can you please supply the full formula in Text (not an image) - change names if you have to
Verified answer

vinmam123 89 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thank you!, Never mind..I managed it with below formula with many trail and errors. Below formula is working just fine)

Below formula On gallery, "Item" property it worked
Filter(SortByColumns('sharepointlist name',"Created",Descending),'Created By'.Email=User().Email)
Regards,
Vinayak