cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stevenbaron86
Frequent Visitor

Flow evaluates string of numbers as integer or something, removing leading 0's

Edit: spoiler i was wrong.

 

Screenshot below is creating an item in a separate sharepoint list. Both "key" keys (eugh, yea i know) in both lists are formatted as a single line of text. In the screenshot you can see the inputs show key's value as "0093", and the output is "93". The solve I had was to use the expression string(triggerOutputs()?['body/key'])

 

stevenbaron86_0-1625721529806.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @stevenbaron86 :

I've made a test but did not encountered the problem you mentioned:

1\My List

vbofengmsft_0-1625728763175.png

2\My Flow:

vbofengmsft_1-1625728780415.png

Result

vbofengmsft_2-1625728823711.png

What is in your screenshot is an action or trigger, what exactly does it do? How is it configured?
Could you provide a screenshot of the list? Is the key a ‘single line of text’ column?

Best Regards,

Bof

 

View solution in original post

2 REPLIES 2
v-bofeng-msft
Community Support
Community Support

Hi @stevenbaron86 :

I've made a test but did not encountered the problem you mentioned:

1\My List

vbofengmsft_0-1625728763175.png

2\My Flow:

vbofengmsft_1-1625728780415.png

Result

vbofengmsft_2-1625728823711.png

What is in your screenshot is an action or trigger, what exactly does it do? How is it configured?
Could you provide a screenshot of the list? Is the key a ‘single line of text’ column?

Best Regards,

Bof

 

View solution in original post

By luck I still had an old run I could test against about 22h later, replaced string(triggerOutputs()?['body/key']) with the dynamic "key' content, and... I cant replicate the issue ¯\_(ツ)_/¯ 

 

I'm a bit embarassed. I cant think of anything I changed that would have fixed the problem. In the absence of evidence to back my claims, I humbly concede this was user error. Thanks for your quick response last night.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,349)