Answered

Help with Sharepoint

(0) Share

Report

Posted on by antonio_piernav

125

Hello, can someone help me? I'm trying to create a flow that gets rows from a sharepoint list, inserts them into an excel file and sends this file to an outlook recipient that is using powerapps.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

MarkStokes 561 on at

Like (0)

Report
Copy link

Link copied!

Hi Antonio,

Why don’t you share with us what you have tried so far and where you are struggling?

- Mark

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @antonio_piernav ,

Do you want to get rows from the SharePoint list then insert them into an Excel table, and send the file to a recipient?

Is it a specific file? And the recipient is always the same?

I have created the flow likes below. In my scenario, the file is specific, after all the items are inserted from SharePoint list to Excel table, get the file from OneDrive for Business folder and send an email to a user with the file attached.

Screen shots like below for your reference:

Best regards,

Mabel

Was this reply helpful? Yes No
antonio_piernav 125 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much, that has helped me a lot, but what I can not do is a filter from the OTHERS column that is a date but with an text format ejem(04/09/2019) with the current day (utcnow ('dd / MM / yyyy ')

some Help?

Thanks

Was this reply helpful? Yes No
antonio_piernav 125 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @antonio_piernav ,

Thanks for sharing the screen shot.

I am afraid that there is something wrong with the code you are using in the Filter query field.

Please surround the function utcnow() with the single quote. And make sure the column of OTROS has the same format with utcnow.

Best regards,

Mabel

Was this reply helpful? Yes No
antonio_piernav 125 on at

Like (0)

Report
Copy link

Link copied!

What I can not do is get elements of sharepoint, pass them to excel filtering by yesterday's date (day -1) and send that excel by email? How can this be done?

Was this reply helpful? Yes No