Unanswered

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

(0) Share

Report

Posted on by George_Po

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

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
George_Po 14 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No