download sql server data base file

[GeekAlf_Pro]

Hi There,

i'd like to propose, in my app, to download a csv file from a sql server view.

I made a flow with power automate that works fine, but my question is : 

how can i let the user choose the directory ?

Thanks

[chsanche · Accepted solution]

Hi @GeekAlf_Pro 

Why do you need to select a directory? If you already a flow that creates the file, you just need to use the Download() function, no need to select a directory.

Best Regards,

[GeekAlf_Pro]

Hello @chsanche,

thanks for your response, that's what i was looking for.

the app will be used mainly on PC, so it's OK.

for my personnal culture, it doesn't work on device like iphone or Android ?

i've another question :

in my data, in some field, there are some special characters like Carriage Return and Line Feed (CRLF). i didn't find the way to vanish them

replace(body('Créer_un_tableau_CSV'),'\n',' ')

Do you know how ?

thanks