Answered

Numbers in strings do not show in output

(0) Share

Report

Posted on by Community Power Pla...

Hello everyone,

I am currently facing an issue with my Power Automate flow during which data is fetched from a PowerApp collection, parsed into a JSON format which is then used to create a CSV table (that I finally download for later use).

The input numbers are stored as strings because of databases constraints.
Also one of the collection (the code is the same for all of them only gets the first field of one column whereas all the others are fetched correctly).

I thank you in advance for your help,

Loïc.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,478 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

The first thing I notice is that there might be a mismatch in the name of the columns in the parse json schema with the action column names in the actual json.

Can you double check if your schema properties should not be Prix_Total_HT instead of Prix_total_HT_Bordereau and Prix_unitaire_HT instead of Prix_unitaire_HT_Client?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Looks like that was it, I feel dumb looking at it for hours.
Now I have to figure why my collection only gets the first value of the database.
Thanks a lot @Expiscornovus !

Was this reply helpful? Yes No