Unanswered

Filter excel and create PDF out of filtered excel

(1) Share

Report

Posted on by Community Power Pla...

Hi,

I created a flow that grabs data from an sql database, then fills them into an excel sheet and then creates a pdf. That works perfectly.

Now, I would like to filter the excel sheet by date and then create a pdf out of the filtered excel. Does anybody now if it is possible to filter an excel by date with Flow?

Thanks in advance.

Best regard just_Domi

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yuazh-msft on at

Like (1)

Report
Hi @Anonymous,

Could you please share more details about the excel file?

Where is the excel file saved in?

I have made a test on my side to create a excel file in my onedrive for business as below:

You could refer to screenshot below to create the flow:

The expression of the Date field in the Insert row action as below:

item()?['Date']

The expression of the Title field in the Insert row action as below:

item()?['Title']

The flow would run successfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi Alice,

Thank you for your solution. The Flow works perfectly. (see in pictures)

Overview:

Best Regards
Just_Domi

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-yuazh-msftcan you have it save to a word template?

Was this reply helpful? Yes No