Filter Gallery to Display the SQL column Descending Number Only

[na12063]

Sort(
    Filter('SQL TABLE NAME ',
        Created_By = CreatedBy.Text
         ),
        id, 
        Descending 
    )

I have incremental column that generates unique number for every new row. So, I am trying to get that number (descending ) created by me and add to line item, so I can you same number multiple time for each line item.

With the code I provided it is displaying the right descending number into gallery but when I am creating line item collection for desceding number is not catching the descending. How would be the best way to display from sql only descending and add that number to collection -- line item with no issue. 

Thanks in advence 

Best Regards

[Anonymous]

Hi @na12063 how are you progressing with this?

@Anonymous 

[na12063 · Accepted solution]

@TopShelf-MSFT,

Sorry for late respond but is working fine the code I have displayed above.