cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Refresh not working

Hello,

 

I have been experiencing issues with the powerapps refresh function.

 

I have an excel worksheet in OneDrive that has multiple tables which I pull to get the data into the application. I have added items into the excel table and tried to refresh the data in powerapps, but the items do not show up. 

 

Code Below:

 

OnSelect(SortByColumns(Search(Table5, Text_Search_Box_3.Text, "problem","companyname","companynum"), "companyname", If(SortDescending1, Descending, Ascending)))

 

OnVisible(Refresh(Table5))

 

Also in the excel table the new items do not have a "__PowerAppsId__".

 

Could someone help me fix this issue?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Refresh not working

I figured it out.

When I was adding new rows to the table in Excel I was pasting information that was not in the same table format.

I entered in the information manually into the table to ensure it was the same format and it worked!

View solution in original post

2 REPLIES 2
Highlighted
Frequent Visitor

Re: Refresh not working

I'm still pretty new with PowerApps but I noticed that you're using the OnVisible property.
If the item is becomes visible once the screen has loaded , this action will not trigger again.
It's similiar to the OnStart property for the application. 
That might be why your application is not refreshing the content.
I don't know what your setup within the application is however, so more information might make things clearer. 🙂

Highlighted
Advocate I
Advocate I

Re: Refresh not working

I figured it out.

When I was adding new rows to the table in Excel I was pasting information that was not in the same table format.

I entered in the information manually into the table to ensure it was the same format and it worked!

View solution in original post

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,753)