web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I do not konw what is ...
Power Automate
Answered

I do not konw what is wrong with the flow

(0) ShareShare
ReportReport
Posted on by qiuyun

I do not konw what is wrong with the flow，No matter what I do, my conditional expression is always false，below is my flow

qiuyun_0-1708930608792.pngqiuyun_1-1708930637628.pngqiuyun_2-1708930666665.png

qiuyun_3-1708930690584.png

5、

div(float(concat(length(body('筛选数组')),'.0')),length(outputs('启动并等待审批_copy')?['body/responses']))
Categories:
General topics
I have the same question (0)
  • v-mengmli-msft Profile Picture
    v-mengmli-msft Microsoft Employee on at

    Hi @qiuyun ,

     

    I recommend you add a compose before the condition and test again to check the result of the expression.

    Hope you can provide screenshots about the result.

     

    Best regards,

    Rimmon

     

  • qiuyun Profile Picture
    qiuyun on at

    Hi

    i do not konw I don't know which one is right

    qiuyun_0-1708934943440.png

    Start and wait for approval copy code
    {
      "responses": [
        {
          "responder": {
            "id": "e61b8afb-b0d8-4630-bc5a-04dc07e60f2b",
            "displayName": "Wang,Yanling (YFI,EXT,Shanghai,CN)",
            "email": "yanling.wang-ext@yanfeng.com",
            "tenantId": "ea960b61-ff0f-4499-8763-5a5084af34cc",
            "userPrincipalName": "yanling.wang-ext@yanfeng.com"
          },
          "requestDate": "2024-02-26T01:21:47Z",
          "responseDate": "2024-02-26T01:22:04Z",
          "approverResponse": "同意"
        },
        {
          "responder": {
            "id": "9976d97b-5bad-4f45-8b44-c8a648d2825e",
            "displayName": "Chang,Qiuyun (YFI,EXT,Shanghai,CN)",
            "email": "qiuyun.chang-ext@yanfeng.com",
            "tenantId": "ea960b61-ff0f-4499-8763-5a5084af34cc",
            "userPrincipalName": "qiuyun.chang-ext@yanfeng.com"
          },
          "requestDate": "2024-02-26T01:21:45Z",
          "responseDate": "2024-02-26T01:32:15Z",
          "approverResponse": "拒绝"
        },
        {
          "responder": {
            "id": "2001126a-6270-4024-98fa-4d82536dfbd7",
            "displayName": "Zhou,Xiaoqing (EXT,Shanghai,CN)",
            "email": "xiaoqing.zhou-ext@yanfeng.com",
            "tenantId": "ea960b61-ff0f-4499-8763-5a5084af34cc",
            "userPrincipalName": "xiaoqing.zhou-ext@yanfeng.com"
          },
          "requestDate": "2024-02-26T01:21:47Z",
          "responseDate": "2024-02-26T01:32:05Z",
          "approverResponse": "同意"
        }
      ],
      "responseSummary": "审批者: Wang,Yanling (YFI,EXT,Shanghai,CN)，yanling.wang-ext@yanfeng.com\r\n答复: 同意\r\n答复日期: 2024年2月26日 1:21:47\r\n答复日期: 2024年2月26日 1:22:04\r\n\r\n审批者: Chang,Qiuyun (YFI,EXT,Shanghai,CN)，qiuyun.chang-ext@yanfeng.com\r\n答复: 拒绝\r\n答复日期: 2024年2月26日 1:21:45\r\n答复日期: 2024年2月26日 1:32:15\r\n\r\n审批者: Zhou,Xiaoqing (EXT,Shanghai,CN)，xiaoqing.zhou-ext@yanfeng.com\r\n答复: 同意\r\n答复日期: 2024年2月26日 1:21:47\r\n答复日期: 2024年2月26日 1:32:05",
      "completionDate": "2024-02-26T01:32:16Z",
      "outcome": "同意, 拒绝, 同意",
      "name": "4ed8b454-d7f4-4dfc-96e8-42458a756366",
      "title": "Test课程认证",
      "requestDate": "2024-02-26T01:21:43Z",
      "expirationDate": "9999-12-31T23:59:59Z",
      "priority": "Medium"
    }
    qiuyun_1-1708935085764.png

    2、

    [
      {
        "responder": {
          "id": "e61b8afb-b0d8-4630-bc5a-04dc07e60f2b",
          "displayName": "Wang,Yanling (YFI,EXT,Shanghai,CN)",
          "email": "yanling.wang-ext@yanfeng.com",
          "tenantId": "ea960b61-ff0f-4499-8763-5a5084af34cc",
          "userPrincipalName": "yanling.wang-ext@yanfeng.com"
        },
        "requestDate": "2024-02-26T01:21:47Z",
        "responseDate": "2024-02-26T01:22:04Z",
        "approverResponse": "同意"
      },
      {
        "responder": {
          "id": "9976d97b-5bad-4f45-8b44-c8a648d2825e",
          "displayName": "Chang,Qiuyun (YFI,EXT,Shanghai,CN)",
          "email": "qiuyun.chang-ext@yanfeng.com",
          "tenantId": "ea960b61-ff0f-4499-8763-5a5084af34cc",
          "userPrincipalName": "qiuyun.chang-ext@yanfeng.com"
        },
        "requestDate": "2024-02-26T01:21:45Z",
        "responseDate": "2024-02-26T01:32:15Z",
        "approverResponse": "拒绝"
      },
      {
        "responder": {
          "id": "2001126a-6270-4024-98fa-4d82536dfbd7",
          "displayName": "Zhou,Xiaoqing (EXT,Shanghai,CN)",
          "email": "xiaoqing.zhou-ext@yanfeng.com",
          "tenantId": "ea960b61-ff0f-4499-8763-5a5084af34cc",
          "userPrincipalName": "xiaoqing.zhou-ext@yanfeng.com"
        },
        "requestDate": "2024-02-26T01:21:47Z",
        "responseDate": "2024-02-26T01:32:05Z",
        "approverResponse": "同意"
      }
    ]
    qiuyun_0-1708935218342.png

     

  • v-mengmli-msft Profile Picture
    v-mengmli-msft Microsoft Employee on at

    Hi @qiuyun ,

     

    If you are using the Chinese option, then your condition's criteria should also be in Chinese. This is what is causing your filter results to be empty.

    Please modify it and test again.

    vmengmlimsft_0-1708936081222.png

     

     

    Best regards,

    Rimmon

  • qiuyun Profile Picture
    qiuyun on at

    In my old version, what I wrote here was 同意

    But the condition still shows false

  • v-mengmli-msft Profile Picture
    v-mengmli-msft Microsoft Employee on at

    Hi @qiuyun ,

     

    At least we first ensure that the Filter array can filter out approved responses.

     

    Also, I suggest you modify your first response to hide some private information to protect your information.

     

    After completing the modifications above, I suggest you insert a compose and put the expression here to test and show me the results of compose.

    vmengmlimsft_1-1708938885178.png

     

    Best regards,

    Rimmon

  • qiuyun Profile Picture
    qiuyun on at

    I'll show you  tomorrow. 

  • qiuyun Profile Picture
    qiuyun on at

    hello

    Please refer to the screenshot attached. The situation remains unchanged.

    qiuyun_0-1708998574172.pngqiuyun_1-1708998589061.pngqiuyun_2-1708998630446.pngqiuyun_3-1708998639466.png

     

  • Verified answer
    v-mengmli-msft Profile Picture
    v-mengmli-msft Microsoft Employee on at

    Hi @qiuyun ,

     

    After re-testing, I found that the problem lies in the filter array's filtering condition. The outcome is the result of the entire approval, not the approval result of each person. This causes the result of Filter array to always be empty.

     

    Please modify the expression in filter array:

    item()?['approverResponse']

    vmengmlimsft_0-1709003218459.png

     

     

    Best regards,

    Rimmon

     

  • qiuyun Profile Picture
    qiuyun on at

    Thank you very much, it's particularly useful

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro - Series II

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 450

#2
Haque Profile Picture

Haque 366

#3
Valantis Profile Picture

Valantis 349

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans