How to automate data validation on SharePoint?? Also how can I relate columns??

[Sayantan365]

Hi how can I automate data validation on SharePoint. Every week I have to work allocation and then data validation on SharePoint which takes a lot of time... If only we could automate all of that..

[#2]

You've not given a lot of detail but have a look at flows in Power Automate.

[#3]

Hi.. Suppose there is a list in excel with some columns such as case ids, login ids, date, case link, etc and some empty columns which are to be filled by working on those case ids login wise. We work on SharePoint so every week I export the list to SharePoint and then I do data validation manually which takes a lot of time...data validation as in selecting the column type as choice and setting the required choices for each column that is to be filled. Can this be automated so that I don't have to do the data validation manually??