Unanswered

How to pass collections (Data Type: Table) from Power apps canvas to Power automate

(0) Share

Report

Posted on by Ameen1989

I have a collection stored in a variable.

ClearCollect(UpdatedData, ForAll(Gallery3.AllItems,{Age:TextBox1_1.Value, Name:TextBox1.Value, Position:TextBox1_2.Value}));

The updated information is appearing in the UpdatedData var as a datatype table. I now want to pass this to a power automate flow.

I have called the power automate flow in power apps canvas and I am using the following code to pass the collection:

NewData.Run(JSON(UpdatedData));

The problem is, it shows an error Invalid Argument Type(Text). Expecting a record value instead.

How can I pass this collection to a flow? All of this code is written in a single button.

In flow I am using the PowerApps(V2) with a collection var and a ParseJson which has the content Collection and the schema

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Ameen1989

Can you check your flow run history and show which action cause this error code "Invalid Argument Type(Text). Expecting a record value instead. ".
And can you show your flow configuration in your side?

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Ameen1989 82 on at

Like (0)

Report
Copy link

Link copied!

I didn't even run the flow. I only wrote this code and it highlighted the error

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Ameen1989

Thanks for your response!

Can you check if your Power Apps V2 input is a Text type? As your error code seems to mean your flow need a record type ..

If this , can you try to refresh your flow in Power app.

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Ameen1989 82 on at

Like (0)

Report
Copy link

Link copied!

Yes, it is input type text. I have also attached an error I am seeing in power apps canvas

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Ameen1989

Can you save your flow and refresh your flow in Power app.

And can you delete your code and try to use this:
Set(varFormattedJSON , JSON(UpdatedData, JSONFormat.IndentFour&JSONFormat.IgnoreUnsupportedTypes));
YourFLowName.Run(varFormattedJSON );

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Ameen1989 82 on at

Like (0)

Report
Copy link

Link copied!

It is still giving the same error 😞

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Ameen1989

This is really strange , can you try to create a new flow to test from scratch ?

This is my test expression:

This is my flow:

It works good in my side:

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Ameen1989 82 on at

Like (0)

Report
Copy link

Link copied!
I deleted and recreated the flow, the connection and the gallery but I am still facing the error. I think I found why this is happening. It looks like the Power Apps v2 trigger is only accepting the record value. Since the data is of type table and using JSON, converts it to type text, it does not accept it because it wants a record. So, I used this code and was able to pass the first record from the table.

YourFlowName.Run( First(YourDataTable) )

However, I am facing a couple of more issues:

1.) I am using a power apps v2 trigger and a compose to view the outputs like you suggest. The flow runs successfully but instead of using the output, the compose gives a link which says click here to download. Clicking on it doesn't do anything.

2.) I then tried ParseJson but I get the following error message
Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'.

Does this mean the record is not getting passed from power apps to flow?

I looked at other tutorials and for everyone the above JSON format which you provided in power apps is working but for me it isn't. Do I need to update the flow to receive it as data type text?

Was this reply helpful? Yes No