cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Brian13
Level: Powered On

Retrieve (search, Lookup, filter, firstN, First, Last, LastN ) the one and only record from a table

Hello

Not sure I'm doing this the best way, but I'm using a single record (single field) table to store the last refresh date of a data set and I want to show this in my app. However, I cannot get Search, Lookup, Last, First, LastN, FirstN to work when there is only one record in the table. If I add a second record no problem.

Has anyone else found this and is there a work around.

I'm using an excel spreadsheet in OneDrive as the datasource and these formulas work with two rows of data but not with one:

First(tblLastRunDate).DateLastRun

LookUp(tblLastRunDate,DateLastRun<Today()+100,DateLastRun)

brian

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Retrieve (search, Lookup, filter, firstN, First, Last, LastN ) the one and only record from a ta

Hi @Brian13,

 

I afraid that you are posting in the wrong forum.

If you have problem on Power apps, you could post it in the Power apps forum:

https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1

 

Best regards,

Alice

 

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Retrieve (search, Lookup, filter, firstN, First, Last, LastN ) the one and only record from a ta

Hi @Brian13,

 

I afraid that you are posting in the wrong forum.

If you have problem on Power apps, you could post it in the Power apps forum:

https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1

 

Best regards,

Alice

 

View solution in original post

Brian13
Level: Powered On

Re: Retrieve (search, Lookup, filter, firstN, First, Last, LastN ) the one and only record from a ta

thank you

sorry

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,993)