Answered

Some columns do not receive values in the Excel file using power automate flow.

(0) Share

Report

Posted on by hitakshi

162

Hi @Anonymous @PowerAutomate @automate @AutoMatey @automate3 @HAutomate @IAutomate @powerautomate88 @powerautomate17 @apowerautomate @mtpowerautomate ,

In your Power Automate flow, I have an action "Add a row into a table", when I am using the "Add a row into a table" action to add data to an Excel table some columns do not receive values in the Excel file and all columns are correctly mapped.

this is a flow:

these two columns are not recieving values in excel.

Thanks for any help.

Hitakshi Chauhan

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Michael E. Gernaey 53,974 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @hitakshi

I notice in your Headers listed, you have Spaces in front of the name of the Header, in the bottom two.
Do the headers have spaces in them? If not please remove them and try again.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
hitakshi 162 on at

Like (0)

Report
Copy link

Link copied!

Hi @FLMike,

Thanks for your reply and solution.
I tried this but it is not working.

Was this reply helpful? Yes No
Michael E. Gernaey 53,974 Moderator on at

Like (1)

Report
Copy link

Link copied!

@hitakshi

unfortunately you are not giving me anything to help you, I don't want to keep guessing.

If there is no data there, then you aren't supplying any data. Use a compose before the add a row and validate that the properties you are assigning actually have data.

Also since it wasnt before, be 10000% sure you are providing the exact header correctly or it wont.

Good luck.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No