cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Trim for a field

Hi,

 

I need to trim one of my share point field and insert into SQL table. Could you help me with the function? For example: share point get items field name is "Residual_Date".

 

Annotation 2019-08-02 190448.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Anonymous 

 

The value in the trim function ResidualDate should be picked from dynamic content 

Not manually entered

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

9 REPLIES 9
Dual Super User II
Dual Super User II

Hi @Anonymous 

 

Use the trim function in an expression 

example : trim(dynamiccontentyourfield)

 

Trim function removes leading and trailing whitespaces

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous
Not applicable

Do you mean to say like this?

 

Annotation 2019-08-02 202326.jpg

Hi @Anonymous 

 

Use the expression pane

 

Within this pane trim(yourfield)

 

 Capture.PNG

 

Anonymous
Not applicable

I get some error.

 

Annotation 2019-08-02 202326.jpg

Hi @Anonymous 

 

The value in the trim function ResidualDate should be picked from dynamic content 

Not manually entered

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

Anonymous
Not applicable

I tried expression but still flow failed.

 

Annotation 2019-08-02 202326.jpg

Hi @Anonymous 

 

You are still hardcoding ResidualDate

 

It needs to come from dynamic content

 

First enter trim() in expression

Then switch to dynamic content to read the residula date value

 

trim(<dynamic ccontent picked residual date>)

Anonymous
Not applicable

I am really sorry for so many questions. Could you let me know which one I need to choose here? I don't see residual date in dynamic content after typing trim in expression. I also don't see "see more" option.

 

Annotation 2019-08-02 202326.jpg

Hi @Anonymous 

 

If this is running in a for loop action

 

use the following expression

 

trim(item()?['Residual_Date']) 

you can type the above directly in the expression field

 

 

If this is not running in a for loop

 

Regards,

Reza Dorrani

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

 

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (16,840)