How do I filter data based on a field and Lastsubmitted id
I Need to find the lastsubmitted ID in a sharepoint list. based on a variable
Thanks
David
My current Formula looks like this:
Filter(t_nsc_trackcode_LogIn_and_LogOut_Daily, NscRacfid = lbl_User.Text)
Solved! Go to Solution.
You can create a variable Onvisible:
Set(LastSubmitted,Last(Sort(Datasource,Descending)).ID)
Then filter:
Filter(t_nsc_trackcode_LogIn_and_LogOut_Daily, NscRacfid = lbl_User.Text And ID=LastSubmitted)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
You can create a variable Onvisible:
Set(LastSubmitted,Last(Sort(Datasource,Descending)).ID)
Then filter:
Filter(t_nsc_trackcode_LogIn_and_LogOut_Daily, NscRacfid = lbl_User.Text And ID=LastSubmitted)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
The problem with that is 30-40 people data entering and I need the last ID for that person specifically.
Dave
This is patching to specific ID
ok this is somewhat working but the Admin_Logged_Out: Now() keep reverting to yesterdays data ??
Patch(
t_nsc_trackcode_AdminLogIn_and_AdminLogOut_Daily,
First( Filter( t_nsc_trackcode_AdminLogIn_and_AdminLogOut_Daily, ID = TextInput2.Text ) ),
{
NSC_ID_Racfid: lbl_Racfid.Text,
Racfid_Name: lbl_associate_name.Text,
Admin_Logged_Out: Now()
}
);
Hi @DAVIDPOWELL :
Could you tell me:
I assume your data source is a SharePoint list.
Firstly,let me explain why you encounted this problem.
The key is that your current time zone is inconsistent with the SharePoint site's time zone.When you save data, the time will be adjusted according to the time zone of the SharePoint site by default.
Secondly,there are two ways to solve this problem.
1\Set the region of the SharePoint site to your current region
2\Use the dateadd function to add the time zone deviation value based on the current time
for example:
Patch(
t_nsc_trackcode_AdminLogIn_and_AdminLogOut_Daily,
First( Filter( t_nsc_trackcode_AdminLogIn_and_AdminLogOut_Daily, ID = TextInput2.Text ) ),
{
NSC_ID_Racfid: lbl_Racfid.Text,
Racfid_Name: lbl_associate_name.Text,
Admin_Logged_Out: DateAdd(Now(),8,hours)/*I assume the time is off by 8 hours*/
}
);
Best Regards,
Bof
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
192 | |
67 | |
46 | |
41 | |
22 |
User | Count |
---|---|
246 | |
120 | |
83 | |
76 | |
70 |