cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Sharepoint list transfer only filled fields to E-Mail

Flow_ges.PNG

Hello, I'm building a flow that when a new Item was created in a sharepoint list, the data was sent in an email. I am now looking for the best way to transfer only the filled fields of a Sharepoint order list via e-mail. This should include the piece field and the article column name. The rest works without problems, I think without a loop it will not work. Thank you for your help.

BadBert

4 REPLIES 4
Highlighted
Dual Super User III
Dual Super User III

Re: Sharepoint list transfer only filled fields to E-Mail

@BadBert 

In order to show some columns only, this post from John Liu can be useful for you

http://johnliu.net/blog/2018/4/how-to-use-select-to-simplify-create-html-table-and-create-csv-in-mic...

Please note I am not sure if you want to show a few columns ('peace' and 'article') either from a sharepoint list item; or from all sharepoint list entries. John's examples are related to a bunch of sharepoint list entries, that's why he creates an HTML table

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Community Support
Community Support

Re: Sharepoint list transfer only filled fields to E-Mail

Hi @BadBert ,

 

Do you want to send value for non-null fields?

Please provide more details and we would provide proper workaround for you.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Sharepoint list transfer only filled fields to E-Mail

Hi v-bacao-msft, 

thank you for your answer. I dont need to send one Value for non-null fields. 

Only the completed fields of the order will be e-mailed with the article name (column name) and the filled field.

On a sharepoint page, I have created an order form with Powerapps. which is based on this simply sharepoint list.

As a backup there is still the sharepoint list with all orders in which you can check the order.

In this existing flow now, I would have to write all the articles in the e-mail and put the forwarded filled fields behind it. Null and non- null fields.

But I only need the completed and ordered Items. Best regards. BadBert

E-Mail.PNG

Highlighted
Frequent Visitor

Re: Sharepoint list transfer only filled fields to E-Mail

John's post only creates one HTML table. I need a best solution for unfilled fields, so they are not displayed the complete Column. Thank you.

E-Mail.PNG

 

 

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (3,859)