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

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Get Today's data from ...
Power Pages
Unanswered

Get Today's data from MySQL database on Power Apps Portal

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi Experts,

I have a requirement where I need to display the data from MySQL database on the Power Apps Portal. The data in MySQL database table is updated with fresh data everyday by truncating the table. But when I get the data to Power Apps entity from the MySQL database and display it using entity view on the Portal, the fresh data gets appended along with previous data. I need only the current day's data to be displayed on the Portal by truncating the previous day's data.

Could anyone please suggest on how to achieve this?

Thanks in advance..

Categories:
Power Apps portals
I have the same question (0)
  • v-bofeng-msft Profile Picture
    v-bofeng-msft Microsoft Employee on at

    Hi @Anonymous :

    Do you want to filter the data of the day based on a certain date field and display it in Portal?

    my suggestion is:

    • Create a view
    • Set filter criteria(Refer to the GIF below)
    • Then use the view in the portal

    C3.gif

    In this case, I filter the records whose modification date is today.

    Best Regards,

    Bof

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @v-bofeng-msft ,

    Thanks for the reply. I tried using the filter on the view. Actually I need to filter for a field called 'Insertdate' which is present on the database table. But this field is not shown up on the filter by lookup on the entity view. I need to filter the table using the 'Insertdate' column. Could you please suggest on this..

     

    Thanks a lot!

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

    Hi @Anonymous :

    I am not sure why the field cannot be displayed. You can also use the "Modified On" or "Created On" fields, because these two fields store the update time and creation time of the record.

    Best Regards,

    BOf

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @v-bofeng-msft ,

    Thank you again. If I try using 'Created On' or 'Modified On' field it shows up even yesterdays data for 'Insertdate' field. I need to have a filter for Insertdate field to show only today's data.. Any suggestion on this please?

    Thank you!

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

    Hi @Anonymous :

    Could you tell me :

    • Does your entity have the Insertdate field?
    • What is its data type?

    I tried to insert a Date and Time type field "Insertdate" into my custom entity, and finally I could find it in the filter.

    1.JPG

    Best Regards,

    Bof

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @v-bofeng-msft ,

    I have pulled the data to the entity from MySQL table. In the Entity view I can find the InsertDate field which has Date and time data type. I can find all other fields present on the entity on the filter by page except for InsertDate using which I need to filter. Below is the screensnips,

    entityview.png                         filter.png

    I have added table from database today. So its showing up only today's date on the entity view. I have tried adding filter for the table with yesterday's date. But I am not able to filter by InsertDate field.. 

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

    Hi @Anonymous :

    Because I can't reproduce the same problem,I suggest you create a new entity and see if the problem still exists.

    Best Regards,

    Bof

  • OOlashyn Profile Picture
    OOlashyn 3,498 Most Valuable Professional on at

    Hi @Anonymous ,

     

    Make sure that your field is marked as searchable. If it is not marked it will not appear in the filters. Open your field in the maker portal and check Searchable checkbox (see attached screenshot).

    Searchable field.png
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Thanks a lot @OOlashyn .. Now I am able to find the InsertDate field on the filter by page..

     

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

    Hi @Anonymous :

    Has the problem been solved?
    Is there anything else I can help?
    Please consider mark your solution as a solution to help others.
    Best Regards,
    Bof

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

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 56

#2
Valantis Profile Picture

Valantis 28

#3
omkarsupreme Profile Picture

omkarsupreme 24

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals
Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans