英文:
Logic app to check if a row in azure table storage contains specific value
问题
要求
创建一个逻辑应用以从表中读取数据。如果某行的某列“region”包含特定值，则该行必须插入到另一个表中。
问题
我可以使用“获取实体”操作从存储表中获取所有实体。我放置了一个“对每个”循环来迭代所有实体。但是，在“条件”操作中，我无法检查每条记录的特定列值。
英文:
Requirement
Create a logic app to read data from a table. If a row contains a particular value for a column "region", then that row must be inserted in to another table.
Issue
I am able to get all the entities from storage table using "Get Entities" action. I placed a for each to iterate through all entities. However, in "Condition" action, i am unable to check for particular column value for each record.
答案1
得分: 3
你可以在“获取实体”操作下添加一个参数（“选择查询”），然后在其中输入“region”。然后使用以下表达式获取“region”列的值：
items('For_each')['region']
英文:
You can add a parameter("Select Query") under the "Get entities" action and type "region" in it.(please refer to the two screenshots below)
Then use the expression below to get the value of "region" column:
items('For_each')?['region']
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论