Missing columns when Sending JSON data to Power Automate

(0) Share

Report

Posted on 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

a33ik 3,306 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
bennytam 4 on at

Like (0)

Report
Copy link

Link copied!

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
)
)
)

Was this reply helpful? Yes No
a33ik 3,306 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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?

Was this reply helpful? Yes No
bennytam 4 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No