We have the need to generate files with a fixed-width data format. Has anyone figured out how to do this from a Power Automate Cloud Flow? I'm able to create a CSV files, but not seeing any actions for fixed-width. Do I need to create a CSV and write something else to convert it?
field_10
(my list's internal name for 'US State') from the current item in the "Apply to each" loop with two spaces, then extracts the first two characters of the resulting string. You just need to change the dynamic value for the field, the padding, and the number of characters based on your length requirement for each specific field. This ensures that each field will always meet the specified length requirement, regardless of whether it contains data--fields that didn't exist in my list would simply have a blank value ('') in place of the dynamic content.substring(
concat(items('Apply_to_each')?['field_10'],
' '
),
0,
2
)
concat(
outputs('Compose_Field1'),
outputs('Compose_Field2'),
outputs('Compose_Field3'),
outputs('Compose_Field4'),
outputs('Compose_Field5')
)
stampcoin
87
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1