Hi All,
My Datasource is- Sharepoint
I am using Datatable to display few records in powerapps front screen after updating the records via excel upload . In which i have few columns with datatype "Single Line of Text".
Column 1 - Single Line of Text
Column 2 - Single Line of Text
Result of these two columns should be "Yes/No".
I need to set a data validation wherever user mentioned other values than "Yes/No" while updating the records. User is not going to update the records one by one. 100+ rows of records updated in excel format and data uploaded using powerapps, power automate flow. For this reason only, keeping the column data type as "Single line of Text".
Here my query is to do the data validation on these columns. Instead of "Yes/No" if any of the column is having incorrect data, then different color code should be applied to the particular row to indicate the user that, format of data is incorrect.
I tried to keep the validation check on "On Select" of particular column in datatable. But unable to find solution. Could anyone please help.
