I create a similar Excel table with you, it names table7 and it looks like below:
>Save the table on Dropbox, create a connection from PowerApps to it.
>Then add a Dropdown control, set its Items property as: Table7.Day
>Add a Gallery control, set it Items property as: Filter(Table7,Day=Dropdown1.Selected.Value)
On the Gallery, add another several Text box controls so that you can show all the columns.
Hope my steps could be a reference for you. If you need more help, please feel free reply.
Based on your data source, if you want to use Date picker control, you could configure the Items property of the Gallery control as:
Please check these documentations for a reference:
I just test this issue again on my side, I can select the date from the Date picker control.
Please make sure you are using the actual name of the Date picker control in the formula.
Please try again with it. If you are still getting this issue, please provide your code and a screenshot of your app configuration for a further investigation.
What is the error message when you hover over "DatePicker2"?
(In future please name your threads more descriptively, so it is easier for us to pick out threads we can try and help with).
You can use the Day function to extract the day component from the date picker's selected date, instead of using text manipulation (which is not always accurate, since different locales have different order for day/month/year). In the app below:
The gallery's Items property is set to the following:
Filter(Tabela; Dias = Day(DatePicker1.SelectedDate))
In a table with only 1 month worth of data (what you sent in the first post), it will show a single item (if it exists).
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!