英文:
Microsoft Flow, email with table when .csv is saved in Sharepoint
问题
我已经将这个问题1粘贴在这里,并且建议已经帮助我解决了大部分问题,但我在完成它时遇到了困难,需要Stack Overflow的帮助。
基本情况是,我让R每天运行一次脚本。偶尔,该R脚本会“找到”一些东西,并将结果保存为一个.csv文件到SharePoint文件夹中。
我希望Flow能将.csv文件的结果发送给我。我已经先前解决了如何让Flow给我发送简单通知或附加文件,但现在我更希望表格位于电子邮件中。类似于这样:
我现在的进展:
我几乎已经让它工作了。流程将触发,它将解析数据,然后向我发送一个包含部分数据的表格,但看起来乱七八糟。要么像这样:
其中所有的CSV数据都塞在一列中。或者最近使用了这些设置:
它将所有的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:
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:
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:
Where all of the csv data is crammed into one column. Or more recently with these settings:
It'll put ALL of the csvdata in every column:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论