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:

Connecting to Data

Mobile App

Connectors

All responses (5)

Answers (1)

PonceletSeba 81 on at

Like (1)

Report
Re: Unsupported format to JSON, False notification of included media.

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.
akselmb 65 on at

Like (0)

Report

Re: Unsupported format to JSON, False notification of included media.

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

Like (1)

Report

Re: Unsupported format to JSON, False notification of included media.

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

Like (0)

Report

Re: Unsupported format to JSON, False notification of included media.

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
Verified answer

akselmb 65 on at

Like (1)

Report

Re: Unsupported format to JSON, False notification of included media.

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?