News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows When dataverse row is ...

Power Automate - Using Flows

Unanswered

When dataverse row is added , add row into excel

(0) Share

Report

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.

All responses Img

All responses (11)

Answers Img

Answers (0)

v-jefferni on at

Like (0)

Report

Re: When dataverse row is added , add row into excel

Hi @KT61 ,

You just need to replace 'Date' with you own column name then set the expression for the corresponding field.

Best regards,
KT61 347 on at

Like (0)

Report

Re: When dataverse row is added , add row into excel

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?
v-jefferni on at

Like (0)

Report
Re: When dataverse row is added , add row into excel

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,
KT61 347 on at

Like (0)

Report

Re: When dataverse row is added , add row into excel

Thanks, was looking in the wrong place. got the choice sorted, now to try the time.
v-jefferni on at

Like (0)

Report

Re: When dataverse row is added , add row into excel

Hi @KT61 ,

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

Best regards,
KT61 347 on at

Like (0)

Report

Re: When dataverse row is added , add row into excel

Unfortunately, still the same
v-jefferni on at

Like (0)

Report
Re: When dataverse row is added , add row into excel

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,
KT61 347 on at

Like (0)

Report

Re: When dataverse row is added , add row into excel

Hi, thanks.

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

Like (0)

Report
Re: When dataverse row is added , add row into excel

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,
KT61 347 on at

Like (0)

Report

Re: When dataverse row is added , add row into excel

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

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,651 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,997 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans