Power Platform Community Forum Thread Details

I have a gallery with data, the cells of which are colored according to some condition.
Screenshot 2023-10-19 193923.png
Now I am exporting data using pcf control made by yashag2255. But I need that, along with data import, according to the same condition, cells in Excel are colored.

And the result should be something like this:

Is there any option on how to do this?

Categories:

Building Power Apps

Hi @Anonymous ,

I think you should be able to do that with the "Run script" action of the Excel Online (Business) connector. But it will not go hand on hand with your PCF component. The PCF component will simply export the content in excel. The option that I am suggesting here is that you store the exported excel in SharePoint and then from there use Run Script action and do the rest of things.

Here are a few links that might be helpful to learn about using Office Scripts with Power Automate:

- Announcing support for Office Scripts in the Excel Online (Business) connector
- Run Office Scripts with Power Automate
- Call scripts from a manual Power Automate flow
- Pass data to scripts in an automatically-run Power Automate flow

You can first try to use the recorder to record the set cell color action to learn how to do that with Office Scripts code. Then add you own script logic like matching cells, etc. After you have tested your code within Excel Online, you can add the "Run script" action to your flow.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB