Enter data Lively - After creating a Column

[Anonymous]

Hello Community,

I have a column as below; I need to one more column “Comments” where I need to manually enter some text.

So, I added a Custom column with empty data as below:

Now I want to enter data in the Comments Column as below in the visual and get the report saved:

Name	Comments
Orange	This may be a Fruit / Color
Yellow	This is a color
Apple	This is a Fruit
Black	This is a color
Grapes	This is a Fruit

Are there any possible ways to achieve this?

Please help me @po @v-frfei-msft @v-diye-msft @sturlaws @v-lid-msft @JosefPrakljacic @Nathaniel_C @v-eachen-msft 

[amitchandak]

@Anonymous , Create a column comment like

Switch([Name],
"Orange" , "This may be a Fruit / Color",
"Yellow" , "This is a color",
"Apple" , "This is a Fruit" // add more as per need
)

Switch(true() ,
[Name]="Orange" , "This may be a Fruit / Color",
[Name]="Yellow" , "This is a color",
[Name]="Apple" , "This is a Fruit"// add more as per need
)
)

[JosefPrakljacic · Accepted solution]

Hey,

what you want is the writeback in the visual. Unfortunately this is not that easy. Either you use PowerApps as input mask (but then you can't write back directly in a table visual) or you use thirdparty providers like Acterys or PowerOnBi for the writeback.

This is not possible with PowerBI alone.

Best regards,
Josef

[sturlaws]

Hi,

Combining PowerApps with direct query mode allows instant update of a visual with data written to the source via the powerapp.

Cheers,
Sturla