Dynamic Excel file name from PowerBI's field

[ngct]

Hi, I am trying to create excel file from PowerBI fields.

And I am trying to rename the Excel file from one of the BI's fields(Title)

Because the "title" is an array, so from action Compose, I have an expression as "First(body('Select_2'))"

However, it turn out with an file name with "___" as prefix and suffix". May I know how to fix this?  

[v-xiaochen-msft · Accepted solution]

Hi @ngct ,

Please use first(body('Select_2'))?['']  instead of first(body('Select_2')).

Best Regards,

Wearsky