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

Flow to update item Percent Complete column in Sharepoint

Hi,

 

The flow that I'm having issues with is associated to a SharePoint list wherein the % complete column value will update depending on the status of an item. I used an Update Item action and set "% complete" to be 30 using flow after the run I checked the item in SharePoint to see if the update take effect but it shows 3,000 instead of 30 even though I set the column max value to 100 only.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Flow to update item Percent Complete column in Sharepoint

Hi @varevalo ,

 

I have made a test on my side and the issue is confirmed on my side, as an alternative way, we could enter 0.7 or 0.9 in the % Complete column in microsoft flow currently instead of the 70 or 90.

Also I would post this issue to my product team, if the issue is solved, I will reply here.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Flow to update item Percent Complete column in Sharepoint

Hi @varevalo ,

 

What is the column type of the % complete column?

Could you please share a screenshot of the configuration of your flow?

Could you please share the run history of the flow?

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Frequent Visitor

Re: Flow to update item Percent Complete column in Sharepoint

Hi Alice,

 

What is the column type of the % complete column?

----The column type is Number Column type.png

Could you please share a screenshot of the configuration of your flow?

---- If the task is Approve the item will get updated and will set Project status value to "For IMPL" and % Complete should be set to 90 if not then it will be for "Testing" set to 70

Flow Config1.pngFlow Config2.png

 

Could you please share the run history of the flow?

----On the history it says % complete value is set to 70 for testing

 

Run History.png

 

----but on the actual output it says 7,000%

 

Task Result.png

 

Hoping you can help me resolve this issue.

 

Thanks,

Vanessa

Highlighted
Community Support
Community Support

Re: Flow to update item Percent Complete column in Sharepoint

Hi @varevalo ,

 

I have made a test on my side and the issue is confirmed on my side, as an alternative way, we could enter 0.7 or 0.9 in the % Complete column in microsoft flow currently instead of the 70 or 90.

Also I would post this issue to my product team, if the issue is solved, I will reply here.

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

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
Users online (4,031)