If you do not want to use the Apply to Each loop after a Dataverse List rows action you can use the following in a Dynamic Content / Expression box to directly use a field’s value in e.g. Compose action:
first(outputs(‘List_rows’)?[‘body/value’])?[‘apx_fullpath’]
instead of apx_fullpath you can use whatever field name you need for the entity that’s been queried before.
Original Post https://code2life.blogspot.com/2023/01/power-automate-avoid-apply-to-each-for.html