Unanswered

Navigating from selected Calendar date to specific page depending on the selected date (NOT USING SHAREPOINT)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi!

I am trying to create a booking app function where the user selects a date from a calender (not the template calendar screen, i have created from scratch) and once they have clicked on the date it navigates them to a specific screen which displays all the bookings for that sepcific date.
A filter function could possibly be used in some way?
calendar screenscreen i would like to navigate to but it must be specific to the date selected

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous

Assuming that the date selected from the calendar control is stored in a variable (lets say, SelectedDate). Now to filter the results on the second screen, you can use Filter as below expression:

Filter(DataSourceName, 'Date of List' = SelectedDate)

Here, DataSourceName refers to the name of the Data Source used. 'Date of List' is the column, that is storing the date we want to match. This will work if both the 'Date of List' and SelectedDate are in date type formats. If this differs you can use Text() or DateValue() functions to modify them to specific formats.
For more info, please refer:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for your help! The formula seems to be okay except the 'invalid argument type' shown in the screenshot above. Is there any way of overcoming this error? It does not give much information on it. @yashag2255

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

You need to refer to the value here rather than referring to the control itself. If you are referring to a variable then its value needs to be passed. If this control text has the value exactly in the same format as the attribute, then you can modify your expression as:

Filter(DataSourceName, 'Date of List' = 'Choosen Date Display'.Text)

If the formats differ, please share more details about how you are getting the selected date, i want to know the result that is used in the app. Also, share the formula on the control 'Choosen Date Display' Text property.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @yashag2255 thanks for your response!

the user selects the date from the calendar, this is then the 'chosen date' which is displayed using the formula above 'the date is then displayed on the next screen using the formula above

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Can you try to modify your expression to:

Filter(DataSourceName, 'Date of List' = _selectionStart)

Hope this helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No