Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

huangapple go评论61阅读模式
英文:

Microsoft Flow, email with table when .csv is saved in Sharepoint

问题

我已经将这个问题1粘贴在这里,并且建议已经帮助我解决了大部分问题,但我在完成它时遇到了困难,需要Stack Overflow的帮助。

我的流程看起来像这样:
Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

基本情况是,我让R每天运行一次脚本。偶尔,该R脚本会“找到”一些东西,并将结果保存为一个.csv文件到SharePoint文件夹中。

我希望Flow能将.csv文件的结果发送给我。我已经先前解决了如何让Flow给我发送简单通知或附加文件,但现在我更希望表格位于电子邮件中。类似于这样:

Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

我现在的进展:

我几乎已经让它工作了。流程将触发,它将解析数据,然后向我发送一个包含部分数据的表格,但看起来乱七八糟。要么像这样:

Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

其中所有的CSV数据都塞在一列中。或者最近使用了这些设置:

Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

它将所有的csv数据都放在每一列中:

Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

老实说,它出现这种问题是有道理的,因为你可以在设置中看到它说每一列都有csv数据,但如果我尝试使用“自动”列,它会报错“必须指定属性'列',除非它是一个数组”。

总结一下:

我如何指定什么放入哪一列?

英文:

I pasted this question here and the suggestions have gotten me most of the way there, but I'm having trouble finishing it up could use Stack Overflow's help.

I have a flow that looks like this:
Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

The basics are that I have R run a script once a day. Every once and a while, that R script 'finds' something, and saves a .csv with the results into a sharepoint folder.

I'd love to have Flow email me the results of that .csv. I've already previously figured out how to get Flow to email me a simple notification, or attach the file, but now I'd prefer that the table was IN the email. Something like this:

Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

Where I am now:

I've ALMOST got it to work. The flow will trigger, it'll parse the data, it'll send me a table with some of the data in it, but it'll look messed up. Either like this:

Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

Where all of the csv data is crammed into one column. Or more recently with these settings:

Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

It'll put ALL of the csvdata in every column:

Microsoft Flow,在Sharepoint中保存.csv文件时发送带有表格的电子邮件。

To be honest it makes sense its screwing up like that because you can see in the settings that it says csv data in every column, but if I try 'automatic' columns it fails with "the property 'columns' must be specified unless its an array'.

In summary:

How do I specify what goes into what column?

答案1

得分: 1

这似乎是一个第三方操作: "解析CSV"。从随后步骤的结果看,内容似乎是JSON格式的。因此,您可以使用内置的解析JSON操作来读取"解析CSV"操作的输出,之后您可以访问各个字段以构建HTML表格。

英文:

This looks like a third party action: "Parse CSV". From the result of the subsequent steps, it looks like the contents is in JSON. Therefore, you can use the built-in Parse JSON action to read the output of the "parse CSV" action, after which you can access the individual fields to build the HTML table.

huangapple
  • 本文由 发表于 2023年6月16日 03:06:12
  • 转载请务必保留本文链接:https://go.coder-hub.com/76484796.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定