Unanswered

JSON parsing error, expected number but got string when calling flow from Canvas app.

(0) Share

Report

Posted on by CU10121450-0

I created the below command on a submit button of the app I am working on, in which, it calls a power automate to create a file on the document library, as well as patches a new item in sharepoint list. I am trying set the ID of the created file to a variable and update the sharepoint list with that variable in a column titled applogoID. However, I received the error of (JSON parsing error, expected number but got string).

// Upload file to SharePoint

AppRegUploadFileToSharePoint.Run({

file: {

name: First(Attach_AppDisplayImage.Attachments).Name,

contentBytes: First(Attach_AppDisplayImage.Attachments).Value

}

});

// Set variable to capture the ID of the uploaded file

Set(varFileID, Value(AppRegUploadFileToSharePoint.Run({file:{name: First(Attach_AppDisplayImage.Attachments).Name, contentBytes: First(Attach_AppDisplayImage.Attachments).Value}}).id));

// Convert varFileID to a number

Set(varFileID, Value(varFileID));

// Patch App Details

Patch(

'NPA-NIWC PAC Apps',

Defaults('NPA-NIWC PAC Apps'),

AppReg_Form.Updates,

{AppLogoID: Value(varFileID)

}

);

NotificationType.Success;

Navigate(HM_Screen, ScreenTransition.Fade)

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Johnny23
Could you throw a button on the screen somewhere and add this to the OnSelect property:
Set(tempVar, varFileID + 1)

Then:
1. Check if it there's an error when you hit the button
2. Look for tempVar in Global Variables and check what the number is

Was this reply helpful? Yes No
CU10121450-0 on at

Like (0)

Report

Hi,

The number for the tempVar variable is 1.

Was this reply helpful? Yes No
CU10121450-0 on at

Like (0)

Report

also there was no error when I clicked the button @DJ_Jamba

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

OK - The problem is not there then.
Where and when do you see this message "JSON parsing error, expected number but got string"?
And is it the full message?
Are you able to supply screenshots of where the error occurred without revealing any sensitive data.
It's tough driving in the dark 😂

Was this reply helpful? Yes No
CU10121450-0 on at

Like (0)

Report

Was this reply helpful? Yes No
CU10121450-0 on at

Like (0)

Report

When I click the submit button shown above the error appears.

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

Have a look in your form and check that any fields that should contain numbers, are in fact numbers and not text.

Was this reply helpful? Yes No
CU10121450-0 on at

Like (0)

Report

All the fields above are the correct types. I do not place applogoid as part of the form, but rather trying to patch that field with the ID from the document that is uploaded to the document library.

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Could you try the following:

Add the AppLogoId field to your form and hide it.
In the Update property of the card, enter varFileID

Comment out the top section of your code as highlighted in the first box.

Hard code varFileID for now e.g.

Set( varFileID, 8 )

Then change your Patch to only use your form updates e.g.

Patch( Datasource, Defaults(Datasource), FormName.Updates )

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

For some reason it does not complete the Set code, it's supposed to be:
Set( varFileID, 8 )

Was this reply helpful? Yes No