将Sharepoint导入Excel，Excel函数不起作用 [英] Sharepoint import into Excel, the Excel Functions do not work

问题描述

嗨我有一个将数据发送到excel文件的流程（它是一个客户端请求..）

我不能为我的生活找出为什么功能对导入的数据不起作用，如果我删除日期导入的单元格并重新手动输入日期工作正常。

数据是日期列和值以及excel功能如下？

= MIN（IF（$ B $ 2：$ B $ 3000 = $ I14，$ D $ 2：$ D $ 3000））

解决方案

您好ShaneOz，

您可以检查从SharePoint导入的日期列值  是否为excel文件中的日期类型。

根据我的研究，请检查以下类似帖子：

无法让Excel识别列中的日期

Excel格式化不起作用f或尝试进行中心对齐时的某些单元格

此外，由于您使用Microsoft Flow将数据导出到Excel，我建议您在Microsoft Flow论坛中创建一个新线程：

https://powerusers.microsoft.com/ t5 / General-Flow-Discussion / bd-p / FlowForum

我们建议适当发布的原因是您将获得最合格的受访者群体以及其他合作伙伴定期阅读论坛可以分享他们的知识，也可以从与我们的互动中学习。

感谢您的理解。

致以诚挚的问候，

Grace Wang

Hi I have a flow that sends data to an excel file (its a client request..)

And i cannot for the life of me find out why the function does not work on the imported data, if i delete the date imported cell and re-manually type in the date it works fine.

The data is a date column and a value and the excel function is below?

=MIN(IF($B$2:$B$3000=$I14,$D$2:$D$3000))

解决方案

Hi ShaneOz,

You can check if the date column value  which imported from SharePoint is date type in excel file.

Per my research, check the following similar posts:

Unable to get Excel to recognise date in column

Excel formatting not working for some cells when trying to do center alignment

Besides, since you use Microsoft Flow to export data to excel, I suggest you creating a new thread in Microsoft Flow forum:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/bd-p/FlowForum

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thanks for your understanding.

Best regards,

Grace Wang

这篇关于将Sharepoint导入Excel，Excel函数不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！