Now that PowerApps supports SQL and Azure SQL DB views, you can use the Row_Number() windowing function to get your sequential numbers :) This gets around issues where you don't have an ID column, or your ID column is not guaranteed to be sequential (e.g. because there have been deletions) or you want to sort by something other than the ID column. Note that Filters and Sorts (on fields on either than the ID) applied within PowerApps will still jumble up the highlighted rows, just as with the method presented here. An even better solution would be if PowerApps galleries had their own RowNumber property...
That's right - this function would not work for shading if the IDs are not sequential. I point out in the video that this doesn't mean you can't use that function for other reasons, it just wouldn't work for shading in that case. (You could always create a custom column in your data source that would work with even/odd numbers though.)
I want to create power app where I can upload 200images in PDF form in onedrive where one can arrange and display section wise.Is there any step by step instructions of creating it.I want to provide the color red if someone views it otherwise remain black
Please post this question on the Community Forum as it isn't directly related to the video. You should do a search for the "PDF viewer" in our PowerApps site documentation (docs.microsoft.com), it may be helpful as well. Thank you for visiting, come back again soon!
Now that PowerApps supports SQL and Azure SQL DB views, you can use the Row_Number() windowing function to get your sequential numbers :)
This gets around issues where you don't have an ID column, or your ID column is not guaranteed to be sequential (e.g. because there have been deletions) or you want to sort by something other than the ID column.
Note that Filters and Sorts (on fields on either than the ID) applied within PowerApps will still jumble up the highlighted rows, just as with the method presented here.
An even better solution would be if PowerApps galleries had their own RowNumber property...
It's not working if you have a filtered gallery because ID are not sequentially :(
That's right - this function would not work for shading if the IDs are not sequential. I point out in the video that this doesn't mean you can't use that function for other reasons, it just wouldn't work for shading in that case. (You could always create a custom column in your data source that would work with even/odd numbers though.)
I want to create power app where I can upload 200images in PDF form in onedrive where one can arrange and display section wise.Is there any step by step instructions of creating it.I want to provide the color red if someone views it otherwise remain black
Please post this question on the Community Forum as it isn't directly related to the video. You should do a search for the "PDF viewer" in our PowerApps site documentation (docs.microsoft.com), it may be helpful as well. Thank you for visiting, come back again soon!