You’re offline. This is a read only version of the page.
Announcements
17
I have SharePoint list with an app name and open_count.
and a gallery using powerapps for makers.
Each time an app is opened from my gallery, this list is patched and updated to reflect the count it has been opened.
My app returns a list off all the apps in our environment
Sort(
Filter(
AddColumns(
PowerAppsforMakers.GetApps().value,"Open_Count",LookUp(Dashboard_Apps_Favorites,properties.displayName=App_Name_sp).Open_Count),
properties.userAppMetadata.includeInAppsList=true
&& StartsWith(properties.displayName,App_Search_1.Text)
&& properties.displayName<>"GCHHS PowerApps Dashboard")
,Open_Count
,Ascending)
I'm trying to add the open count as a new column. and then sort the list so the app with the highest open count comes to the top of the gallery.
the fx is not complaining but its not sorting and "thisitem.open_count" when placed in a label does not return anything but the column is available.
please help 🙂
Hi @Michael22902290 ,
After a quick look, there are two points.
1\ You want to sort the list so the app with the highest open count comes to the top of the gallery but in your formula you use the Ascending as the third parameter of the sort function.
I think you should use Descending instead of Ascending.
2\ You said that the thisitem.open_count has no value in lable, So I guess the filter function returned empty table.
In other words, there is no item meet the filter criteria. Please check it.
Best Regards,
Wearsky
Share
Report
All responses (
Answers (
