PVA to pass variables to excel sheet on SharePoint?

Like (0) Share

Report

Posted on 13 May 2022 11:36:23 by VeeLearnMSFT

508

The screenshot below is a file on SharePoint that is used to calculate rates based off of the Pay Grade Slotting, wether they work Night Shifts, Licensure date or Years of Service as of a Point in Time, in this case 12/21/2021. Weather they are full time employee.

Based on the pay grade and the years of service the calculator selects the years of experience and the rate for that Grade...Th experience is in half year increments. Just curious if its possible to pass these variables to the file in Sharepoint and bring back the rate which in this case is $54.14. Is this possible?

Categories:

General

I have the same question (0)

Summarized by AI

AI generated content may be incorrect

Did you find this summary helpful?

All responses (6)

Answers (1)

Verified answer

Expiscornovus 32,205 Most Valuable Professional on 23 May 2022 at 08:04:21

Like (1)

Report
Re: PVA to pass variables to excel sheet on SharePoint?

Hi @VeeLearnMSFT,

Can you try these three expression below to split and extract the values into three output variables in the last action of your flow?

First value:

replace(replace(split(body('Run_script'), ',')[0], '[', ''), ']','')

Second value:

formatnumber(float(replace(replace(split(body('Run_script'), ',')[1], '[', ''), ']','')), 'C2', 'en-us')

Third value:

formatnumber(float(replace(replace(split(body('Run_script'), ',')[2], '[', ''), ']','')), 'C2', 'en-us')

Was this reply helpful? Yes No