Hi @GOVIND RAJ ,
Thankyou for using Microsoft Q&A platform and thanks for posting your query.
As I understand your ask, you want to know if there is any way to sort array in ADF . Please let me know if my understanding is incorrect.
Unfortunately , there is no sort function available that can be utilized in writing expression in ADF. But here is one workaround I have found , you can load the data in SQL table and use order by clause to achieve your desired result.
- Use Append variable inside ForEach activity to compose the array .
- After append variable , use look up activity inside foreach to load each item as separate record in a table using this query.
insert into tablename select @{item()} ; select 1 as output
- Use a look up out of the ForEach block, to get the output by using order by clause.
select * from tablename order by columnname
Sharing gif for reference:
Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on
button and take satisfaction survey whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how - Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators