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