You’re offline. This is a read only version of the page.
104
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.
If you use are using a gallery then each row of the data source will be its own row in the gallery and you can use something like this on the bg fill or border color for that item:
If(Lower(ThisItem.Col1Value) <> "yes" Or Lower(ThisItem.Col1Value) <> "no", Color.Red, Color.White)
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
Share
Report
All responses (
Answers (
