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.
In order to show some columns only, this post from John Liu can be useful for you
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
Hi @BadBert ,
Do you want to send value for non-null fields?
Please provide more details and we would provide proper workaround for you.
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
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!