Unsupported format to JSON, False notification of included media.

(0) Share

Report

Posted on by PonceletSeba

Dear Power Apps Community,

Whilst building an application I ran into following problem:

I am using the provided code to convert a table (ColNewLabels) to a JSON for further processing, the varRecordsPrint returns this notification: value passed to JSON function contains media and cannot be processed. (The value does not contain any media/attachements.)

Set(varRecordsPrint; CollectionNewLabels);;
Set(VarFormatJson; JSON(varRecordsPrint;JSONFormat.IndentFour));;

Here is the data used:

Schermafbeelding 2023-08-02 094846.png

Legenda in English:
Eén tekstregel = 1 line of text
Datum en tijd = date&time

Persoon of groep = person or group

Getal = number

Any idea's?

Kind regards,

Sébastien

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

akselmb 65 on at

Like (1)

Report
Copy link

Link copied!

Hi @PonceletSeba

Could it be that the person/group-columns contain images/profile pictures

____________________________________________________

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up. perhaps?

Was this reply helpful? Yes No
PonceletSeba 81 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thanks for replying,

The person/group columns are not being used. I've also tried excluding them by using DropColumns(), didn't work either.

Kind regards

Was this reply helpful? Yes No
PonceletSeba 81 on at

Like (1)

Report
Copy link

Link copied!

@akselmb on further investigation this seems to be the issue after all. Thanks.

Was this reply helpful? Yes No
akselmb 65 on at

Like (0)

Report
Copy link

Link copied!

No problem. You could also try to swap your format to JSONFormat.IncludeBinaryData and see if that helps.

Was this reply helpful? Yes No
PonceletSeba 81 on at

Like (1)

Report
Copy link

Link copied!
Ended up excluding the columns and using following properties:
Set(varRecordsPrint;DropColumns(CollectionNewLabels;"Author";"Editor";"Modified";"Created"));; Set(VarFormatJson; JSON(varRecordsPrint;JSONFormat.IndentFour & JSONFormat.IgnoreUnsupportedTypes));;

Thanks again.

Was this reply helpful? Yes No