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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,874)