I want to convert a value into a fixed text

[TimHofman]

Hello!

I am fairly new to the platform and have so far designed a flow in which a completed form via forms is converted into a completed PDF and this is then emailed to the entered email address.

However, I have a number of questions in my form for which a 'rating' of 1, 2 and 3 can be given. However, I want to provide a fixed text behind those values ​​instead of the 1, 2 or 3 in the PDF document.

What step should I add for this? Can someone help me on my way?

Thank you in advance!

[Pstork1]

If the values are whole numbers then you can use a Switch to set a text value for each of the values.  YOu can read about the Switch action here: Add switch actions to workflows - Azure Logic Apps | Microsoft Learn

[Sayan]

Hey @TimHofman 

can you please share the workflow?

If you are using Power Automate Desktop, then you can follow the below solution:

Display Custom Form:

Extract the Rating Value: 

where Rate is the "ID" of the Dropdown 

Use the "If" condition to check the Rating and you can set variable According to the Ratings.

Main Flow:

------------------------------------------------------------------------------------------------------------------------------

If my suggestion helps you, please gives it a Thumbs up 👍  and Marks as a Solution ✔️. Which motivates to solve more problems.

Thanks,

Sayan Patra | Consultant RPA Developer

[TimHofman]

Thanks for the quick replies! 

I am using the cloud flow, and after watching some content on the Switch action, i made some adjustments. 

But the value keeps empty now. Here is my flow:

I created 3 cases, with the following input:

After that it goes into creating the files, my flow setup is as follows:

I thought i put in the value at ' Update file properties' 

Is it not possible this way, or am I overlooking some things?

[Pstork1]

He mentions in the original post that its a cloud flow, not a desktop flow.

[Pstork1]

You are using a Condition, not a Switch. Conditions are good for either or settings. But you want to set a value based on three different conditions.  Instead of the Condition it should look something like this.

[Sayan · Accepted solution]

Hey @TimHofman 

Sorry for the miscommunication. You can follow the below solution using Power Automate Cloud: 

Solution:

Before Checking the Condition convert the Rating Value into Float. Then Check Condition it will works.

Main Flow: 

Step 1: 

Initialize the Rating String value

Step 2:

Convert it to Float

Step 3:

Check condition 

------------------------------------------------------------------------------------------------------------------------------

If my suggestion helps you, gives it a Thumbs up 👍 and Marks as a solution ✔️. Which motivates to solve more problems.

Sayan Patra | Consultant RPA Developer

[TimHofman]

Thanks for the tips once again.

Why do i get this error?

I got the next setup:

I made sure the Initialize variable Rating is 'type: String' and i got the switch action on the response field of the form. It gives the result i want: 

I got case 2 set to: Equals 2 but after that it gives me the error. 

[TimHofman]

Your solution worked, I get the correct text in my PDF. Thank you very much! It's all quite new to me, but I'll definitely look into it further. I will see if there are any good tutorials on Youtube etc..

If I may be so bold, is there an 'easy' way to add an icon/image to this? Where 1 give an red icon, 2 an orange and 3 gives a green one. Since it should be a report with an informal look. 

Have a great weekend!

[Pstork1]

Is the value coming in as a number or text? you may have to convert it to text if that is what is coming in to have it evaluate correctly