Skip to main content
Community site session details

Community site session details

Session Id : KJ9ymwqg9fOCZ8D/R95jzn
Power Automate - General Discussion
Unanswered

How to check whether certain fields are filled in the list for a certain status

Like (0) ShareShare
ReportReport
Posted on 20 Jan 2024 09:52:25 by 14

Hi all,

I have one list on Sharepoint, that will be used by users as well as by IT. We use Canvas with mandatory fields for users. IT must proceed items after users, add additional date and change status. The task is to prove if IT have filled out some fields at certain status. For example, if status is "Clarification", than the field "IT Responsible" must be filled out and so on.

 

The ideal solution would be

1. use of a separate “Status-Field” list and one check in accordance with this list when entering data. (in Canvas?)

Other solution would be less convenient:

2. Sending a letter about lack of data after changing the status.

 

Now I was able to send a letter when status was changed, but specific fields are empty, i.e. simplified version 2 (Power Automate).

 

Are options 1 and 2 possible at all? If yes, to how?

 

Many thanks,

George

  • George_Po Profile Picture
    14 on 22 Jan 2024 at 08:29:16
    Re: How to check whether certain fields are filled in the list for a certain status

    Hi Qi,

     

    I use exactly this way and it has it has flaws.


    1. This works not at the moment of entering data into the form, but afterwords
    2. You need to create a separate flow for each status.
    3. If you need to change the state of a field (mandatory or not) or if a new field is added, then you need to change the flows. I would like to see this as a configuration table of required fields from two columns Status-Field and use this table in one check.

     

    BR

    George

     

     

     

  • v-qiaqi@microsoft.com Profile Picture
    on 22 Jan 2024 at 02:56:44
    Re: How to check whether certain fields are filled in the list for a certain status

    Hi @George_Po,

    In Power Automate, there is a trigger named when an item or a file is modifed, we could use it to trigger a flow when a field is modified, then use the Get Changes for an item or a file (Properties Only) to check if the status is changed and changed to the special one.

    Power Automate SharePoint Get Column Changes - April Dunnam - SharePoint Siren

     

    In a word, idea related to Power Apps is not that ideal, using Power Automate is much more convenient.

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Loading complete