data from survey123 to excel table formatting issue

(0) Share

Report

Posted on by WesDunkin

Good evening all,

I am going to do my best to explain my issue, I am still really new to power automate.

So I am taking data from survey123 and having that data go to a new row in an excel table. Survey123 exports the day as a decimal. the first digit in the data represents the question number the decimal is used to separate, and the second digit represents the selection from the user. So for example 2.4 would represent question 2, selection 4.

I am trying to import the data into the excel table with just the final digit so instead of 2.4 I only want to import 4.

I have tried a few different ways, the first one was using an excel formula =value(right(dynamic content for the question)). I placed this formula directly into my flow using a compose. When I used this method it imported the data into a new row in the table, however it would change all of the previous rows in the column to the same value.

I then tried substring('Dynamic content',2,1). However this would not even run in my flow and cause an error.

This is the error I received:

{

"status": 400,

"message": "The argument is invalid or missing or has an incorrect format.\r\nclientRequestId: 4f98e1df-4c03-4d89-875e-376ac80f856f\r\nserviceRequestId: b25d9779-3c2b-4f54-8272-903d7da0f2a0;8228239b-415f-448c-bfe5-08e90f392fe5;50de994a-4526-4d77-9fa6-e9a8cbd63c36;8b7e7be4-6fb7-48e9-98e1-eadd42155e69",

"error": {

"message": "The argument is invalid or missing or has an incorrect format."

"source": "excelonline-usgv.azconn-gcc-usgv-001.p.azurewebsites.us"

Any ideas comments or suggestions would be greatly appreciated.

Thank you

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Re: data from survey123 to excel table formatting issue

Hi @WesDunkin

Here is the sample flow.

In this example, I have hardcoded the values while adding rows in excel but you could pass the values dynamically as per the need:

=VALUE(RIGHT(@{float('1.2')}))

Output of the flow

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
WesDunkin 16 on at

Like (0)

Report

Re: data from survey123 to excel table formatting issue

@ManishSolanki Thank you for your response, i appreciate it!

When i try to pass the dynamic content through the expression i receive an error stating that the expression is invalid.

If i try to just type the expression in with the dynamic content it i receive a different error

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Re: data from survey123 to excel table formatting issue

Hi @WesDunkin

You need to write an expression for using float function. You could try passing it without using float function if the input value is in decimal format i.e.

=VALUE(RIGHT(<dynamic value>))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
WesDunkin 16 on at

Like (0)

Report

Re: data from survey123 to excel table formatting issue

@ManishSolanki

=Value(right(dynamic content)) is what I originally tried. This does work however it changes all of the previous rows in the column in the table to the new value.

Was this reply helpful? Yes No