cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RikiVitalets
Helper II
Helper II

UPPER CASE from powerautomate to sharepoint not maintained

Hello,

 

I have a flow, that writes to a sharepoint list taking the data from an excel file (first pic).

One field of the new record of sharepoint created is fix "DA SMISTARE" but in the sharepoint list when the record is inserted it comes out like "Da Stimare" like if exists a sort of PROPER function that transform the string. The sharepoint list setting of the column (choice) is also in full upper case (second pic).

Is there a way the string in the proper form as written in power automate (full uppercase)?

Thanks for your help.

R.

RikiVitalets_0-1655391345444.png

RikiVitalets_1-1655391350660.png

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
MarconettiMarco
Super User
Super User

Hello @RikiVitalets ,

you should be able to use the following expression in Power Automate:

 

toUpper('<your value>')

 

On the other hand, you can change the display name of the option set label in SharePoint.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

 

BR,

Marco

View solution in original post

3 REPLIES 3
MarconettiMarco
Super User
Super User

Hello @RikiVitalets ,

you should be able to use the following expression in Power Automate:

 

toUpper('<your value>')

 

On the other hand, you can change the display name of the option set label in SharePoint.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

 

BR,

Marco

RikiVitalets
Helper II
Helper II

Hi @MarconettiMarco ,

 

the display setting of the option set seems already to be upper case

RikiVitalets_0-1656076626092.png

 

 

and the toUpper(<value>) function gives only the very same string.

RikiVitalets_1-1656076802279.png

 

Am I missing something or type mismatching?

 

RikiVitalets
Helper II
Helper II

Well... by the way now I set once again the choice value and it works... who knows. Thanks a lot for your support, by the way, I give your as solution even if I absolutely changed nothing (at least apparently).

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,646)