Power Platform Community Forum Thread Details

Hello.

I have an Excel File as below

Name | Admin | Owner

ABC | TRUE | FALSE

DEF | FALSE | FALE

etc

I want to update my sharepoint list with the same data.

My sharepoint list uses a Choice Column to store TRUE or FALSE, and i have conditional formatting set on it.

When my SharePoint list updates, it updates as lower case.

You can see that when Flow updates my choice column, even though the value is displayed in capitals on the excel, for some reason, it converts to lower case in flow.

I can manually go in and update the SharePoint value inside of SharePoint; but was wondering if anyone could aide me in getting the value to store as uppercase in sharepoint.

I tired using the toUpper() as an expression, but when i use it, it doesnt let me select the excel value to convert to upper.

Any ideas?

Categories:

Power Automate Desktop