When dataverse row is added , add row into excel

(0) Share

Report

Posted on by KT61

347

hi ,

have flow setup when dataverse row is added , add row into excel.

I have drop down with choice in my power app form and these value are showing as numbers in the excel sheet, not text.

I have a date picker also, which is not showing.

Categories:

Using flows

I have the same question (0)

All responses (11)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KT61 ,

For the Choices column value, you can use below expression as dynamic content to populate Excel table:

triggerOutputs()?[‘body/Area@OData.Community.Display.V1.FormattedValue']

or

triggerOutputs()?[‘body/Area_label']

For the date time values to populate in Excel Date column, please refer to below blog:

Power Automate: Convert Date to Excel Number - Manuel T. Gomes (manueltgomes.com)

add(div(sub(ticks(triggerBody()['Start Dime']),ticks('1900-01-01T00:00:00Z')),864000000000),1)

Best regards,

Was this reply helpful? Yes No
KT61 347 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply, getting the following error,
Do I need to delete "Task Category"? and add into brackets?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KT61 ,

Sorry I was using a wrong symbol in the expression.

triggerOutputs()?['body/Area@OData.Community.Display.V1.FormattedValue']

or

triggerOutputs()?['body/Area_label']

Best regards,

Was this reply helpful? Yes No
KT61 347 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks.

Showing blank now in excel sheet when I add the expression, any ideas please? Or do I have something wrong

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KT61 ,

Please check in run history and see outputs of the trigger, you can find the exact name of where the choice value comes from.

The expression on my end is

triggerOutputs()?['body/_crba2_type_label']

change it based on the name on your end.

Best regards,

Was this reply helpful? Yes No
KT61 347 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, still the same

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KT61 ,

You need to check outputs of the trigger instead of this action.

Best regards,

Was this reply helpful? Yes No
KT61 347 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, was looking in the wrong place. got the choice sorted, now to try the time.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KT61 ,

To populate Date columns of Excel table using date time values from dataverse, please refer to below blog:

Power Automate: Convert Date to Excel Number - Manuel T. Gomes (manueltgomes.com)

add(div(sub(ticks(triggerBody()['date']),ticks('1900-01-01T00:00:00Z')),864000000000),1)

Best regards,

Was this reply helpful? Yes No
KT61 347 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, for the converting time formula, where do I put this in my flow? or do I create a manual trigger flow like in the blog, but then where do I put it?

Was this reply helpful? Yes No