Form view based on date picker

(0) Share

Report

Posted on by Livearus

126

Hello everybody,

my knowledge of Power Apps is not very extensive. I have the problem that I have a form which should output data with SharePoint lists. Always only from the last data record (line), or based on the selection of a report period.

Viewing the last report is easy by passing Last (Datasource) to the Item property of the Forumlar. But how do I do it so that a data record (line) can be output based on a date selection.

The "Report Period" is a column with the date and time.

Kind regards

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Livearus ,

Assuming you are selecting the required date with a Date Picker

With( { wData: Filter( DataSource, ID, Descending ) }, LookUp( wData, Text('Report Period',ShortDate) = Text(YourDatePicker.SelectedDate,ShortDate) ) )

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.

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Livearus ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No