Forum

What is the proper ...
 
Notifications
Clear all

What is the proper way to use the ' ' return character in a Power Automate Flow?

2 Posts
2 Users
0 Reactions
176 Views
(@xarzu)
Posts: 4
Active Member
Topic starter
 

What is the proper way to use the '
' return character in a Power Automate Flow?

When working with the functionality of reading data from a cvs file into a dataflow, it is required, I believe, to use a schema.  It seems to me that this schema has to be designed to accommodate the end of a line in the data.  What is the proper way to do this?

 

First of all, It seems that all schemas start like this:

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "Title": {

                "type": [

                    "string",

                    "null"

                ]

            },

After this, the schema lists the individual columns.  Let's say that in our case, we only have three columns, "Name", "Profession" and "Profession-2".  In order to recognize  that we have reached the end of the line as we read data, the
character should be used. I assume this is how it should be done:

 

           "Name": {

                "type": [

                    "string",

                    "null"

                ]

            },

            "Profession": {

                "type": [

                    "string",

                    "null"

                ]

            },

            "Profession-2
": {

                "type": [

                    "string",

                    "null"

                ]

            }

 

Finally, there is the "required" block.

 

        "required": [

           "Name",

            "Profession",

            "Profession-2
",

        ]

What are your thoughts?  Did I get this right?  Is there some sort of documented explanations somewhere outlining the proper use of the /r character?

 
Posted : 20/01/2024 3:53 pm
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi William,

This is a Power Query forum, not Power Automate, sorry we can't help with this.

Regards

Phil

 
Posted : 29/01/2024 7:24 pm
Share: