Answered

Table Records to JSON string

(0) Share

Report

Posted on by adamjones_kkp

Hello,

I have created a sheet with a combo box linked to a table called tblDatabase_Migration, with the items being set by: Filter(tblDatabase_Migrations, active=true) to only show rows that are marked as active. I use the same code in DefaultSelectedItems to make sure they are all selected by default.

I need to be able to turn the table into a JSON object, but when I do it only seems to show two fields: the Dataverse table unique id and a column called title from the table. The code I am using is:

JSON(cmbTables_Migration_Export.SelectedItems, JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes)

It seems to sometimes work fine and then stops working, has anyone come across this issue or have a better way to resolve this?

Thank you,

Adam

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

CarlosFigueira Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Not sure why this is not working, but if you extract the columns you want explicitly you should be able to get it working consistently. Something like

JSON( ForAll( cmbTables_Migration_Export.SelectedItems, { Id: <the column name with id>, Name: <name column>, Address: <address column>, ... } ) )

Since you are choosing the columns directly you also won't need the JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes argument to the JSON function.

Hope this helps!

Was this reply helpful? Yes No
adamjones_kkp 48 on at

Like (0)

Report
Copy link

Link copied!

@CarlosFigueira thank you - this works perfectly

Was this reply helpful? Yes No