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!
Solved! Go to Solution.
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!
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. 🙂
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!