Remove the double Quotes from a MS form Response

(0) Share

Report

Posted on by AhmedSalih

6,678 Moderator

Hello,

I am creating a record in Dataverse table when a MS form response is submitted. One of the Dataverse field is currency type. If the user didn't enter a value in the form, I get "" as value which will not be a valid value for the currency field. I need to remove those double quotes and just enter blank value. I have tried the replace function and it wont work! any ideas. Thank you

To Remove Double qoute.PNG

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

@AhmedSalih ,

Can you show the Data Verse action - Add a new row in design mode ?

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@gabibalaban

The replace Function: > replace(outputs('Get_response_details')?['body/rc9483a12b7b74208a2657a1ae36416c1'],'"','')

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
@AhmedSalih ,

No ... the replace( ) function will not help you in this. What I suggest to do is to check if the amount entered by the user is empty with a formula like this (written in add dynamic content -> expression) and if it is empty to use null constant to be written in DataVerse:

if( empty(outputs('Get_response_details')?['body/rc9483a12b7b74208a2657a1ae36416c1']), null, outputs('Get_response_details')?['body/rc9483a12b7b74208a2657a1ae36416c1'] )

Hope it helps !

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

Thank you so much @gabibalaban , that worked. One thing I didn't know that I can write if condition in an expression in power Automate, this will help me with a lot of things. Do you have a good source of documentation for the expressions?

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report

Here you can find official references as Azure Logic App and PowerAutomate are practically same thing.

Was this reply helpful? Yes No