Answered

UPDATE TASK DETAILS - DESCRIPTIONS AREN'T FULLY POPULATING

(0) Share

Report

Posted on by Nikon23

Hello, I'm having some trouble in PA where a couple of my descriptions come over but not all of them. It seems to be random. Each description shown has content in it in Excel. However, only a couple of pieces of text data has come over. It appears that the ones which did not come over are numbers. And the ones that came over are text. POWER AUTOMATION 1.png Power Automation 2.png

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Nikon23 ,

So you need to use a couple of Compose operators before the Update task action to convert the numbers to texts. You can use string function to convert formats of input parameters, and use the outputs in the action.

Best regards,
Nikon23 2 on at

Like
a
(0)

Report
Copy link

Link copied!

What number do I use as a value? The entire column has different numbers which require conversion.
For each line that gets imported from excel to Planner, I have to have an operation specific to that number? Or can I just say anything that is in number format, convert to text?
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Nikon23 ,

Any values that of type numeric from the outputs of previous Excel action, you will need to convert to Text using string function.

Best regards,