cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Formatting Output

I have three, what should be simple, questions on formatting output from a Get Files (Properties Only) action into an email body:

In the flow below:

  1. Formatting the date/time : I cannot find any way to use the date formatting functions on the value "Issue Date"
  2. Is there a method of inserting spaces between fields in the value column
  3. Is there a way of inserting spaces in the header column names

For both these last questions I have tried using _0020_ and %20 type formatting codes but these just show as typed

 

FlowImage.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Formatting Output

Create a temporary  Compose. This is only so that you can go to expression, type item()?['Date'] and hit ok. Then click in the Compose box. Hit Ctrl-A followed by Ctrl-C then go to your HTML action and hit Ctrl-V and it will appear as a fucntion rather than text

View solution in original post

17 REPLIES 17
Highlighted

Re: Formatting Output

Hi @StevenMoore,

 

I foudn the same problem with the spaces. If you crteate a varibale called space and set it to a single space you can use this varibale to added spaces. Not great but at least it seems to work.

Highlighted
Helper I
Helper I

Re: Formatting Output

Thanks for that one Pieter - that works, any idea on the date formatting?

Highlighted

Re: Formatting Output

This should work:

 

convertTimeZone(utcnow(),'UTC','W. Europe Standard Time','dd/MM/yyyy HH:mm')

Highlighted
Helper I
Helper I

Re: Formatting Output

Tried that previously, see below, it's not so much the command it's how to get that command to work within the Create HTML Table action as it just puts this in as a string:

 

Capture2.JPG

 

Capture.JPG

Highlighted

Re: Formatting Output

I would use a string variable. Then use the above function and include the variable in your html action
Highlighted
Helper I
Helper I

Re: Formatting Output

Pieter

I tried that, following on from your use of the SPACE chatracter, the same happens, there must be some delimiter that I can't find to allow this.

Highlighted

Re: Formatting Output

HI Steven,

 

I tried it via a select. I managed to get the dates formated in an array using the select. Bu the generate table seems to mess things up a bit.

 

But I got it to work at the end:

 

Dates.PNG

Highlighted

Re: Formatting Output

First you need to create a Select like this:

 

convertTimeZone(item()?['Created'],'UTC','W. Europe Standard Time','dd/MM/yyyy HH:mm')

 

SelectAction.PNGCreateHTMLWithDates.PNG

 

To get item()?['Date'] into that Value of the HTML action I crteate a compose where I added the expression then copied the fucntion value and pasted it into the HTML action. Painful but it worked.

Highlighted
Helper I
Helper I

Re: Formatting Output

Pieter

Nearly there, I followed you right up to the point of getting the item into the HTML, I can't get an expression with the item, works perfectly to that point and I can see the reformatted dates in the flow run:

Capture.JPG

Highlighted

Re: Formatting Output

Create a temporary  Compose. This is only so that you can go to expression, type item()?['Date'] and hit ok. Then click in the Compose box. Hit Ctrl-A followed by Ctrl-C then go to your HTML action and hit Ctrl-V and it will appear as a fucntion rather than text

View solution in original post

Highlighted
Kudo Collector
Kudo Collector

Re: Formatting Output

For inserting spaces in the header column, you can just type the name, e.g. Next Review, on any text editor then copy and paste it on the column header. It works for me.

Highlighted
Advocate I
Advocate I

d.Re: Formatting Output

Type it into the expression box, do not type it directly in the field.

Highlighted
Helper II
Helper II

Re: Formatting Output

@Pieter_Veenstra could you describe how you created this space variable? 

Highlighted
Helper II
Helper II

Re: Formatting Output

@Pieter_Veenstra could you describe how you created this space variable? 

Highlighted

Re: Formatting Output

@wojcika , you can initialize a varibale with an expression like this:

 

replace("X","X"," ")

Highlighted
Helper II
Helper II

Re: Formatting Output

@Pieter_Veenstra Thank you so much for responding. I am still struggling a bit, this should be pretty straight forward but I am getting an invalid expression.

 

I basically want to add spaces after "Posted by:" 

Expression.png

Thoughts on this? Any insight would be super helpful. 

Highlighted

Re: Formatting Output

The replace doesn't seem to be right. 

 

in the space variable action can you put the expressions as 

 

concat("post by", "   ")

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Kudoed Authors
Users online (6,746)