Error on flow : Start an approval process and send an email on Microsoft Form submission

(0) Share

Report

Posted on by memento

While testing for the following flow:

error at the first stage

error message:

Invalid form id. Inner message: source array was not long enough. Check the source index, length and the array's lower bounds. (Parameter 'sourceArray')

I checked all the fields entered are following the correct format.

For 'Get Response Details' the response id is also selected.

What could have gone wrong?

All responses (7)

Answers (0)

Santhosh Balakrishnan 169 on at

Like (0)

Report

Re: Error on flow : Start an approval process and send an email on Microsoft Form submission

We attempted to reproduce the error and discovered that need to format a column as 'Currency' on sharepoint list.

Subsequently, in the 'Create item' step of the currency column, utilize the formula float(replace(outputs('Get_response_details')?['body/r61804482e325451184aa7fe02e6c78dc'], '$', ''))

This expression removes the dollar symbol and converts the value to a float. Since the column type is inherently currency, it automatically appends the dollar symbol to the amount.

Let me know if this work for you.

If this solution proves helpful and resolves your issue, kindly consider marking it as accepted. Doing so will aid others who encounter similar challenges in the future.

Regards,
Santhosh Balakrishnan
Apps4.Pro - Trusted Office365 T2T Migration partner. Migrate Exchange, SharePoint, Microsoft Teams, Stream, Yammer, Power Platform between tenants.
Product Specialist - http://www.apps4.pro/
memento on at

Like (0)

Report

Re: Error on flow : Start an approval process and send an email on Microsoft Form submission

Hi everyone,

i managed to solve the approval process by just reusing my previous flow which is working but just change the form in the flow.
which means i use the original form and added the fields that i need instead of using a new form to have those new fields.

Thus, it is not due to whether i use the form id or not since when i reuse my previous flow but change the form (there is a drop down listing to choose the name), the whole flow worked. which means for some reason the flow does not work with the new form which is very strange and since i don't have time to figure the reason, i just use the original form with my added new fields.

But if anyone has similar encounter and you know why, please share.

Now i am onto the next part where after it has all the approval, i added the "Create item" in sharepoint. This part has failed due to the field stated in form is a number/double ie $XXX.XX but the list in sharepoint which i want to create did not state this as the format. However, I tried the formula under the validation part =DOLLAR([Col1], 2) where Col1 is the name of my column in the sharepoint listing (and also the same from the form) but it doesn't recognise.

If anyone knows, please advise.

Thanks !
Santhosh Balakrishnan 169 on at

Like (0)

Report

Re: Error on flow : Start an approval process and send an email on Microsoft Form submission

You can get the form id by opening the form on portal.

If this solution proves helpful and resolves your issue, kindly consider marking it as accepted. Doing so will aid others who encounter similar challenges in the future.

Regards,
Santhosh Balakrishnan
Apps4.Pro - Trusted Office365 T2T Migration partner. Migrate Exchange, SharePoint, Microsoft Teams, Stream, Yammer, Power Platform between tenants.
Product Specialist - http://www.apps4.pro/
memento on at

Like (0)

Report

Re: Error on flow : Start an approval process and send an email on Microsoft Form submission

The form ID in the code shown is actually the form name.
v-bofeng-msft on at

Like (0)

Report

Re: Error on flow : Start an approval process and send an email on Microsoft Form submission

Hi @memento ,

You could find the Form ID in the code view.

Best Regards,

Bof
memento on at

Like (0)

Report

Re: Error on flow : Start an approval process and send an email on Microsoft Form submission

But in the drop down listing, there is only the form name for selection.
How to find the form id ?
Also, i tried created the same flow with another form and there is no error. I followed the same concept with the 2nd form and then the error occur. The only difference is that in the 2nd form i added more fields to fill in but i also check that the test inputs followed the same format ie. if is text then is text (or text with numbers), if is date then is in (M/D/YYYY) as per the form format and also choice input.
v-bofeng-msft on at

Like (0)

Report

Re: Error on flow : Start an approval process and send an email on Microsoft Form submission

Hi @memento ,

Please try removing the trigger and adding it again.

When setting the Form ID, please select from the dropdown menu instead of manually entering the form's name.

Best Regards,

Bof