Missing columns when Sending JSON data to Power Automate

Like (0) Share

Report

Posted on 14 Jun 2024 05:01:33 by bennytam

Hi all,

I was trying to send a table to power automate.

The table has around 15 columns.

I have used showcolumns functions to list out the 10 columns that I needed.

But when it reach power automate, it only received 4 of them.

my code is like :

myfunction.Run(

JSON(

ShowColumns(

mydatasource,

GUID,

'Line No',

Number_text,

name,

Description,

Quantity,

Currency,

Amount,

ExchangeRate,

Unit Cost,

submissiontypevalue

)

When it reach Power Automate, the data will only show 4 columns:
[{"Number_text":"123456","name":"ABC","cr34d_guid":"44a75fb8-1ed8-47cc-9ecb-6ad2a9c00b0f","submissiontypevalue":"A"},{"Number_text":"101101","coaname":"XYZ","cr34d_guid":"1405f215-36a4-4263-b609-72eccb136bc0","submissiontypevalue":"B"}]

All other columns have actual number / string in it.

All responses (4)

Answers (0)

bennytam 4 on 14 Jun 2024 at 08:03:41

Like (0)

Report

Re: Missing columns when Sending JSON data to Power Automate

Thanks a lot! @a33ik

The textbox can only show 3-4 columns , but I got the idea.
Eventually I have to create a hidden gallery for this table and add textboxes for all the columns.
Then I used JSON(Gallery1.AllItems, JSONFormat.IgnoreUnsupportedTypes) to call back the json string and pass to Power Automate.

Works Now!
a33ik 3,304 Most Valuable Professional on 14 Jun 2024 at 06:02:15

Like (0)

Report
Re: Missing columns when Sending JSON data to Power Automate

Did you check if it get properly serialized at the first place? Like adding textbox to the app and assigning

JSON( ShowColumns( mydatasource, GUID, 'Line No', Number_text, name, Description, Quantity, Currency, Amount, ExchangeRate, 'Unit Cost', submissiontypevalue ) )

to the Default property?
bennytam 4 on 14 Jun 2024 at 05:55:38

Like (0)

Report

Re: Missing columns when Sending JSON data to Power Automate

Thanks for pointing out.
It is just a typo when I copy the script to here.
My script would have failed and not receive anything on the Power Automate end if I missed the quotation marks.

myfunction.Run(
JSON(
ShowColumns(
mydatasource,
GUID,
'Line No',
Number_text,
name,
Description,
Quantity,
Currency,
Amount,
ExchangeRate,
'Unit Cost',
submissiontypevalue
)
)
)
a33ik 3,304 Most Valuable Professional on 14 Jun 2024 at 05:49:28

Like (0)

Report

Re: Missing columns when Sending JSON data to Power Automate

Your Unit Cost field has space inside your formula. Shouldn't it be 'Unit Cost'? Are you sure your formula is exactly what you use in your app? I doubt it is.