Question

i have a simple form that have 4 question, that 3 questions need upload file (question 2 is Mandatory)

我试图创造流量,以挽救用于在线挖掘的烟雾数据。

How to extract the URL only and make it to hyperlink?

below is my flow: Thank you very much for your help

Answer 1

Here is a test for your reference:

Here is form

Here is excel:

Here is flow:

File1 return message:outputs( Get_response_details )?[ body/r7cc5c536c5ee45a6bfeb688a5ad2f89c ])

Use json to parse the information returned by file in the Form Then an array will be generated, and then use First to get the first one in the array to avoid using apply to each：

first(json(outputs( Get_response_details )?[ body/r7cc5c536c5ee45a6bfeb688a5ad2f89c ]))?[ id ]

直接从以表格形式归还的档案资料中获取的链接只能由采购处使用。为了使这一联系成为一种共同的联系,我们可以通过[分享联系]建立共享联系。

因此,我们首先使用(产出(产出) Get_response_details ? a)? 这是为了让档案资料在校区查阅。

以同样方式建立其他档案的共享链接

为了以Excel显示连接形式,我们利用聚合物来pl灭 ex子,填充外壳细胞。

 concat( =HYPERLINK(" ,outputs( Create_share_link_for_file_1 )?[ body/WebUrl ], " , , , " ,first(json(outputs( Get_response_details )?[ body/r7cc5c536c5ee45a6bfeb688a5ad2f89c ]))?[ name ], ") )

Here is test result:

友情链接