cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
biterbit
Kudo Collector
Kudo Collector

Is Flow the right tool for Sharepoint list validation?

I have a Sharepoint list that I hope to use to replace an Excel spreadsheet that currently captures an organsation's data. Sharepoint has a serious limitiation in its validation features, in that column-level validation cannot refer to any other column in the list, and the list-level validation allows only one test and one error message.

 

In my case, the spreadsheet contains many date fields and there are validation rules between these: typically that one date must be >= another date. There are about ten of these fields across the list. Column-level validation cannot help (because of the column reference limitation) and, although it would be possible to construct a complex validation test involving all these fields, only one message would be displayed to the user, giving them little idea as to where the issue lay.

 

I have started looking at Flow to augment the basic Sharepoint features but I'm not sure if it's the right solution for fixing this validation problem. Ideally, I would want either a) validation to take place as the user exits the list column and display an error message; or b) for it to take place when the list record is updated, perhaps displaying the first error messages (in order of entry).

 

Is Flow the answer or should I be looking elsewhere for this sort of functionality?

1 ACCEPTED SOLUTION

Accepted Solutions

Hello,

 

in your specific case Flow is probably not the right tool because the error message won't show up in the SharePoint UI.

PowerApps is probably a better choice because with PowerApps you can replace the SharePoint out the box forms with your own custom UI and provide your own error message notification. More on this here https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-list-form

 

KInd regards

 

Serge Luca aka "Doctor Flow"

View solution in original post

1 REPLY 1

Hello,

 

in your specific case Flow is probably not the right tool because the error message won't show up in the SharePoint UI.

PowerApps is probably a better choice because with PowerApps you can replace the SharePoint out the box forms with your own custom UI and provide your own error message notification. More on this here https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-list-form

 

KInd regards

 

Serge Luca aka "Doctor Flow"

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,435)