cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aditya_549
Frequent Visitor

(Flow, SharePoint, PowerApp) Get the last enter value for each unique in child SharePoint list from parent SharePoint list

Hi All,

Background Context:-

I made an tools checkout-check-in system using QR code in PowerApp. All the tools check-out, check-in record is stored in Parent SharePoint list. In PowerApp, due to 2000 rows delegation limit, I am not able to complex formula such lookup(Max(Sortbycolum(Filter="XXXXXX"))) to check for last entered value for XXXX tool when the list grow >2000 rows.

 

Therefore i thought to create a child SharePoint list which only shows last entered value for that unique item.

Need help with.

As a newbie with Flow I am stuck on how to create a flow to automatically update child SharePoint that when a new item is added to parent SharePoint.

I am Have been doing research over google from last one week, but no luck for me. Please help or guide any starting step.

 

The parent SharePoint looks like this

Parent SharePoint List (PowerApp form stored data here)
Equipment NameIDEmailNameSelect DateEmployerSelect one responseMobile Number
D396ZB1anonymousAlpha05/07/20AACheck-out 111
D426ZB2anonymousBravo06/07/20BBCheck-out 2222
D448ZB3anonymousCharlie07/07/20CCCheck-out 3333
D396ZB4anonymousAlpha08/07/20AACheck-In 4444
D426ZB5anonymousBravo09/07/20BBCheck-In 5555
D448ZB6anonymousCharlie10/07/20CCCheck-In 6666
D396ZB7anonymousAlpha11/07/20AACheck-out 7777
D426ZB8anonymousBravo12/07/20BBCheck-out 8888
D448ZB9anonymousCharli13/07/20CCCheck-out 9999
D396ZB10anonymousAlpha14/07/20AACheck-In 11110
D426ZB11anonymousBravo15/07/20BBCheck-In 12221
D448ZB12anonymousCharli16/07/20CCCheck-In 13332
D396ZB13anonymousAlpha17/07/20AACheck-out 14443
D426ZB14anonymousBravo18/07/20BBCheck-out 15554
D448ZB15 Charlie19/07/20CCCheck-In 16665

 

Child SharePoint looks like this (will use child sharepoint to check/show the last status for each tool in power app)

Equipment NameIDEmailNameSelect DateEmployerSelect one responseMobile Number
D396ZB13anonymousAlpha17/07/20AACheck-out 14443
D426ZB14anonymousBravo18/07/20BBCheck-out 15554
D448ZB15 charlie19/07/20CCCheck-In 16665

 

Thank you. Please help

0 REPLIES 0

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,283)