cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BadBert
Level: Powered On

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
Dual Super User
Dual Super User

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





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





Community Support Team
Community Support Team

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.
BadBert
Level: Powered On

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

BadBert
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 417 members 5,542 guests
Please welcome our newest community members: