Power Canvas Application

Like (0) Share

Report

Posted on 19 Nov 2021 10:59:55 by Pugalendhi

Not able to convert text to table in Power Canvas app

Sample Data

"Index", "Mass (kg)", "Spring 1 (m)", "Spring 2 (m)"
1, 0.00, 0.050, 0.050
2, 0.49, 0.066, 0.066
3, 0.98, 0.087, 0.080
4, 1.47, 0.116, 0.108
5, 1.96, 0.142, 0.138
6, 2.45, 0.166, 0.158
7, 2.94, 0.193, 0.174
8, 3.43, 0.204, 0.192
9, 3.92, 0.226, 0.205
10, 4.41, 0.238, 0.232

Need to convert above text to table,

If user attach csv files need to read the content through power automate and display in canvas app.

Requirement: Need to get the csv files from Azure blob and display the contents of csv files in canvas app.

I can able to get csv file content from power automate and not able to display it in canvas app table.

Need suggestions to display the csv content in power canvas app , since content will be varying dynamically to the files getting attached

Categories:

General Questions

All responses (4)

Answers (0)

Pugalendhi 33 on 23 Nov 2021 at 07:14:51

Like (0)

Report

Re: Power Canvas Application

Thank you for the response to my inquiry. I appreciate the information you have provided me with, and I appreciate your prompt reply.
v-bofeng-msft on 23 Nov 2021 at 06:20:42

Like (1)

Report
Re: Power Canvas Application

Hi @Pugalendhi :

I am afraid this cannot be achieved.

First of all, if you want to pass the table from Flow to Canvas App, you need to know the structure of this table first.

Second, if you need to display the table in the Canvas App, you also need to define the file name corresponding to each column.

I suggest you consider saving the CSV file into the SharePoint library, and then get the thumbnail of the file to display the table as a picture.

Best Regards,

Bof
Pugalendhi 33 on 23 Nov 2021 at 04:54:04

Like (0)

Report

Re: Power Canvas Application

Hi Team,

Thanks for the reply.

How to handle dynamic rows and columns since the user will be updating multiple files in Azure blob storage.

And rows, columns will be getting deferred accordingly.
v-bofeng-msft on 22 Nov 2021 at 08:00:34

Like (0)

Report
Re: Power Canvas Application

Hi @Pugalendhi :

I've made a test for your reference:
1\My Flow

Response Body JSON Schema:

{ "type": "array", "items": { "type": "object", "properties": { "Index": { "type": "string" }, "Mass (kg)": { "type": "string" }, "Spring 1 (m)": { "type": "string" }, "Spring 2 (m)": { "type": "string" } }, "required": [ "Index", "Mass (kg)", "Spring 1 (m)", "Spring 2 (m)" ] } }

2\My App:

I think this link will help you a lot：

https://www.thrives.be/dynamics-365-ce/power-automate-parse-csv-files/

Best Regards,

Bof