Answered

Date

(0) Share

Report

Posted on by Alphadrag

164

Hi all, i have an issue here and i am not sure why is it this way. Below attached images would show my flow and outcome. The first image shows how i did my flow and the flow variable is in the correct way i want it. However, when it writes into excel, it changes everything and does not show what i want. (see 2nd image). I hope that you guys can help me and give me a solution on how can i solve this issue. Thank you

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I think the problem is that the Excel cells are in General format, which causes date-looking values to be formatted as dates.

Try changing the cell format to Text (with VBscript or through the UI) or force text formatting by adding a single quote in front of the write-value.

Was this reply helpful? Yes No
Alphadrag 164 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, the excel cells are in date format. How can i write vbscript to force it to be in text format?

Was this reply helpful? Yes No
Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Found this, which seems to be informative: https://stackoverflow.com/questions/31075254/format-cell-from-general-to-text

Was this reply helpful? Yes No
UK_Mike on at

Like
a
(0)

Report
Copy link

Link copied!

I felt you're pain....
This worked for me.

Solved: Excel issue rather than PAD ? - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

To do this dynamically without doing it manually here is the vbscript approach to change from any format to any format.

#6 is the one you need.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Formatting-Features/td-p/1547687

Was this reply helpful? Yes No