Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Dynamic file name using paginated report

Hi,

 

I wanna create paginated excel file name dynamically like below title:

 

I created dynamic name code as below but is it available to have 0000 ea as per its data?

 

 

concat(
'NDPd SMP Creation_',
formatDateTime(convertFromUtc(utcNow(),'Korea Standard Time'),'yyyy'),
'_W',
formatNumber(
add(div(dayOfYear(convertFromUtc(utcNow(),'Korea Standard Time')),7),1),
'00'
),
'.xlsx'
)
 
 

 

 

General Comment
Need Help
Show and Tell
Tips and Tricks

7 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    1 year ago

    Hi Anonymous  -Your dynamic filename formula is correctly generating a name based on the current year and week number, but you want to include "0000 ea" dynamically based on the number of records in your dataset.

     

    eg: 

    concat(
    'NDPd SMP Creation_',
    formatDateTime(convertFromUtc(utcNow(),'Korea Standard Time'),'yyyy'),
    '_W',
    formatNumber(
    add(div(dayOfYear(convertFromUtc(utcNow(),'Korea Standard Time')),7),1),
    '00'
    ),
    '_',
    formatNumber(length(yourDataset), '0000'), // Count of rows with zero padding
    ' ea.xlsx'
    )

     

    Hope this helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Yes correct, let me try with your suggestion. 

      By the way, '0000' is flexible to carry any digit of numbers? not only 4 digits? e.g. 9, 999, 999999, etc 

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

       

       

      it says invalid. 

       

      and what is this part for?  
      '// Count of rows with zero padding'

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        It seems I need to put my dataset in the code right?

        what dataset would that be? 

         

        it has filter in paginated report.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Count doesn't match..

       

  • v-veshwara-msft's avatar
    v-veshwara-msft
    Community Support
    1 year ago

    Hi Anonymous ,

    Thanks for engaging with the Microsoft Fabric Community.
    Just checking in to see if your issue has been resolved.

    If not, since your query involves automating file naming and calculating row counts using Power Automate expressions, we recommend posting it in the Power Automate Community for more targeted support and better visibility.

     

    Hope this helps.

    Regards,
    Vinay.