Unanswered

Concat Table values from Adaptive card to String to Pass to PA Flow

Like (0) Share

Report

Posted on 19 Jun 2023 18:06:53 by ikhan_24

Hi Guys,

I have an adaptive card which is giving a table value of the some states. I want to use the concat function to join the table values into a string and pass it into a PA flows. While I had achieved something similar using the classic version of PVA and Botframework composer I am unable to do so in the unified canvas. I have the array which is giving the following outputs.

How do I join the state1 table values together into a PA flows. I cannot pass a table variable into the PA flows so need to convert it into a string first. Please advise. I did try using the following powerfx fornula Concat(Topic.State1,ThisRecord.Value,",") or tried to use ForAll functions to loop through all the values but am unable to find a solution to join these values together. Help will be appreciated.

Thanks!

Categories:

General

All responses (8)

Answers (0)

Pstork1 66,091 Most Valuable Professional on 19 Jun 2023 at 19:12:36

Like (0)

Report

Re: Concat Table values from Adaptive card to String to Pass to PA Flow

I;m not sure if this helps, but using the sample JSON from the video I was able to parse the items to a Table and then concat the table this way to get the name values

If you can get me a sample of what the output of the adaptive card looks like I can try to help you figure out the exact steps needed.
ikhan_24 31 on 19 Jun 2023 at 19:09:13

Like (0)

Report

Re: Concat Table values from Adaptive card to String to Pass to PA Flow

@Pstork1 Thank you for your reply and all your help. I went over the video but I am still unable to produce the desired outcome on my end. My current issue is I am not sure what the output format is for the adaptive card in the unified canvas. When I created this in the previous PVA version it generally gave a string output as per the adaptive card outputs as shown:
With the unified canvas since it is already segregating the data items into separate variables I am unable to determine the format of the output data from the adaptive card. I am still not sure how I can parse that array as a Json Object and how I can extract just the value of the arrays selected from the adaptive card. It is easier to use a some sort of Join/Concat function in PA or botframework composer to get this done however I am unable to figure out how to achieve this here. If you could give me some example of similar scenario for an array to string that will be great.
Pstork1 66,091 Most Valuable Professional on 19 Jun 2023 at 18:41:34

Like (0)

Report

Re: Concat Table values from Adaptive card to String to Pass to PA Flow

Take a look at the following video. There is now an advanced Step that can Parse JSON directly in PVA. That may help with your issue.

How to parse JSON with PVA - YouTube
Pstork1 66,091 Most Valuable Professional on 19 Jun 2023 at 18:30:29

Like (0)

Report

Re: Concat Table values from Adaptive card to String to Pass to PA Flow

Your previous screenshot was showing the ParseJSON() function. But I tested and you are correct that the JSON() function also isn't supported.
ikhan_24 31 on 19 Jun 2023 at 18:28:41

Like (0)

Report

Re: Concat Table values from Adaptive card to String to Pass to PA Flow

@Pstork1 I am unable to use the JSON function as mentioned in my comments. Unified canvas does not recognize the function
Pstork1 66,091 Most Valuable Professional on 19 Jun 2023 at 18:26:26

Like (0)

Report

Re: Concat Table values from Adaptive card to String to Pass to PA Flow

Not the ParseJson() function. Use the JSON() function. Then use a Parse JSON action in the flow. here's the documentation on the JSON function. JSON function in Power Apps - Power Platform | Microsoft Learn
ikhan_24 31 on 19 Jun 2023 at 18:20:20

Like (0)

Report

Re: Concat Table values from Adaptive card to String to Pass to PA Flow

@Pstork1 unfortunately I cannot seem to use the Json function in the unified canvas. The only formula I can use is ParseJson which is expecting a string variable as input.
Pstork1 66,091 Most Valuable Professional on 19 Jun 2023 at 18:11:36

Like (0)

Report

Re: Concat Table values from Adaptive card to String to Pass to PA Flow

The table should be the equivalent of a collection in Power Apps. Have you tried using the PowerFX JSON() function to generate a JSON string that you can send to the flow? Then use a Parse JSON in the flow to read the values.