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

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Tables

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

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

thank you
sorry
Verified answer

v-yuazh-msft on at

Like (0)

Report

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

Hi @Anonymous,

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