web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

What role does the return character play in a schema?

Posted on by 84

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 \r character should be used. I assume this is how it should be done:

 

           "Name": {

                "type": [

                    "string",

                    "null"

                ]

            },

            "Profession": {

                "type": [

                    "string",

                    "null"

                ]

            },

            "Profession-2\r": {

                "type": [

                    "string",

                    "null"

                ]

            }

 

Finally, there is the "required" block.

 

        "required": [

           "Name",

            "Profession",

            "Profession-2\r",

        ]

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?

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics