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

Community site session details

Session Id :
Power Automate - Building Flows
Answered

How can I check value in all fields in a record?

(0) ShareShare
ReportReport
Posted on by 8

I have a list to contain people like

LazyLazy_0-1611200724360.png

field is single line(contain 1 value) and some fields can be empty, how can I check that how many people was contain in 1 record then save them to array?

 

Thanks.

 

I have the same question (0)
  • Verified answer
    v-litu-msft Profile Picture
    on at
    Re: How can I check value in all fields in a record?

    Hi @LazyLazy,

     

    You could initialize an integer variable to count the number of approver field not empty, steps as below:

    1. Initialize an integer variable set to 0 and name it to Count;

    2. Create condition action determine approver1 if has a value;

    3. use the empty() function:

     

    empty(outputs('Get_item')?['body/Approver1'])

     

    4. If true, increase the Count variable by 1;

    5. Repeat Step 1-4 to check Approver 2- 6.

     

    Screenshot 2021-01-21 165547.jpgScreenshot 2021-01-21 165615.jpg

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard