web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

Help me please!

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

How do I make an app that I select the day and return the results from Cumbica to treliças as a header?

 

imag.PNG

Categories:
  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi Alex2,

     

    I create a similar Excel table with you, it names table7 and it looks like below:

    1.png

     

    >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.

    3.PNG

     

    Hope my steps could be a reference for you. If you need more help, please feel free reply.

     

    Best regards,
    Mabel Mao

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    And IF I CHANGE the dropdown1 by the datepicker?How is it?

  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi Alex2,

     

    Based on your data source, if you want to use Date picker control, you could configure the Items property of the Gallery control as:
    Filter(Table7,Day=Mid(Text(DatePicker2.SelectedDate,DateTimeFormat.ShortDate),3,1))

     

    Please check these documentations for a reference:
    https://powerapps.microsoft.com/en-us/tutorials/show-text-dates-times/
    https://powerapps.microsoft.com/en-us/tutorials/function-left-mid-right/


    Best regards,
    Mabel Mao

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    The datepicker does not work. I can not select the dates.

  • v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi Alex2,

     

    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.

     

    Best regards,
    Mabel Mao

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Here is error!!!

    Capturar.PNG

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Can someone help me?

  • AndyPennell Profile Picture
    Microsoft Employee on at

    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).

     

  • CarlosFigueira Profile Picture
    Microsoft Employee on at

    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:

    ForumPost001.PNG

    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).

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    The datepicker does not work. I can not select the dates.

    Doubt.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 194 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 150

Last 30 days Overall leaderboard