Answered

Converted string to INT how do you return it to the original Get Items data?

(0) Share

Report

Posted on by mad05150

So I'm trying to get data from a SharePoint list. The data is a number formatted as a string.

I've used INT to convert a DaysRemaining string to an integer within the flow, and I can see that it was successful, but I cannot combine it back to the original data to

1. Filter the array on DaysRemaining < 90

2. Create a CSV attachment to an email of the filtered data with other fields.

I know how to capture output to a CSV attachment.

What I'm having trouble with is getting the original data ie. Product, TeamLead, etc connected with the converted integer. So I can filter the array for just the items I want, then output that to the CSV.

Hope I'm explaining this correctly. This is my 3rd day working with Flows 🙂

Thanks!

All responses (5)

Answers (1)

mad05150 on at

Like (1)

Report

Re: Converted string to INT how do you return it to the original Get Items data?

I figured it out. the create table was referencing the wrong output. Thanks for all your help!!!
mad05150 on at

Like (0)

Report

Re: Converted string to INT how do you return it to the original Get Items data?

Ok one last thing. I've added to that function and checked to see if it was less than or equal to 0. Which returns true/false correctly. Can I filter the array to just select the true items?
I can't seem to get that to work.

Thanks!!
Verified answer

abm abm 32,488 Most Valuable Professional on at

Like (1)

Report

Re: Converted string to INT how do you return it to the original Get Items data?

Hi @mad05150

Try the following

Expression I used above is as follows:

int(item()?['TaskId'])
mad05150 on at

Like (0)

Report

Re: Converted string to INT how do you return it to the original Get Items data?

Full disclosure, I've added and deleted so much from the flow trying to learn it. This is where I'm back to currently.
Only have the string conversion left.
abm abm 32,488 Most Valuable Professional on at

Like (0)

Report

Re: Converted string to INT how do you return it to the original Get Items data?

Hi @mad05150

Could you please post a screen shot of your flow?

Thanks