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
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
Proud to be a Flownaut!
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,
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
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.