Skip to main content

Notifications

Community site session details

Community site session details

Session Id : XDsWivIRp6ZeKCk+40feMy
Power Apps - Building Power Apps
Unanswered

Getting your data in PowerApps

Like (0) ShareShare
ReportReport
Posted on 8 Dec 2023 21:30:52 by 20

Hi,

There are lots of posts on this issue and i have tried the suggestions but still the issue for me is not resolved.

I have a PBI rapport set up in the following way. 

 

aftabp_0-1702070173151.png

The Table is live so that every change is visible as soon as the Save button the PowerApp is hit.

 

The issue is that when i click on a record/line one of the following happens:

  • PowerApps load the data so that i can write stuff in it and save it in DVH
  • PowerApps doesnt even try (no spinning wheel at all) and shows: "Getting your data"
  • PowerApps try to load the data (i can see the spinning wheel) but it gives up and leaves me with "Getting your data"

There are couple of things i have done to try to solve the issue:

  • Use the hambuger menu to reduce the size of data shown
  • On OnStart for App i have added: 

 

 

Refresh('MSSQL Datasource');;

 

 

  • There are 2 forms and for each of them, the following for OnSelect

 

 

ResetForm(Name of form)

 

 

 

Categories:
  • aftabp Profile Picture
    20 on 14 Dec 2023 at 09:34:40
    Re: Getting your data in PowerApps

    So, my LiveTabel had columns from both liveTabel and factTabel
    I have removed the columns from factTabel that i was showing in the liveTabel view. This improved the app a bit.

     

    aftabp_0-1702546336506.png

     

  • aftabp Profile Picture
    20 on 14 Dec 2023 at 09:26:52
    Re: Getting your data in PowerApps

    @Ethan_R That is done already

  • Ethan_009 Profile Picture
    4,838 Super User 2025 Season 1 on 09 Dec 2023 at 13:07:16
    Re: Getting your data in PowerApps

    Hi @aftabp ,

     

    If you have a form in PowerApps and it shows "Getting your data" and you do not see the data it means its waiting for the Form command to load which you might have not passed.

     

    To initiate the Form for creating new Record, use 'NewForm(<FormName>);' in PowerApps and for updating existing record use 'EditForm(<FormName>);' (Make sure you pass the Record in the 'Item' property of the Form to show related details.

     

    Hope this helps

  • aftabp Profile Picture
    20 on 09 Dec 2023 at 00:53:56
    Re: Getting your data in PowerApps

    No measure filter on PowerApps

  • lbendlin Profile Picture
    7,699 Super User 2025 Season 1 on 09 Dec 2023 at 00:24:57
    Re: Getting your data in PowerApps

    Do you have a measure filter on the PowerApps visual that makes sure it is only active when a single row in the table visual is selected?

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

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,440 Most Valuable Professional

Leaderboard
Loading started
Loading complete