Power Platform Community Forum Thread Details

Custom Excel sheet which populates 9 fields once you input data into the default field

Hi everyone,

I want to create an excel sheet with 10 different fields so that when I add data to one specific field (the default field) it will automatically auto-populate the other fields grabbing specific product information from that one product in our Portal. Some of the fields will need to grab information from Freshdesk which is a customer support ticket application.

For example if I input the SKU code 8000500 it will automatically auto-populate the other nine fields in the Excel sheet for example like the Colour, Size, Price etc. All of these fields will contain information for that specific product. Most of this information will come from our Portal but I would like the Excel sheet to populate with some information from Freshdesk too like the date a support ticket was created.

I dont need whole tables imported just single items related to the first bit of product information I inputed into the default field in the Excel sheet.

So I need to have a default field where the user has to input the SKU number in and then the 9 other cells are auto-populate automatically grabbing the relevant product informaton from our Portal and from an app like Freshdesk.

Please note that all of this information is product information for a specific product so I want create an Excel sheet that saves the user time in completing all the fields. So instead of them having to copy this information from 10 different fields on our portal and in an app like Freshdesk once we add the first SKU number all the other 9 fields are auto-populated automatically.

Firstly is this possible? And how would I achieve this?

Categories:

General Comment

Hi @CU19061231-1,

Firstly, you are going to need Power Automate for this. Freshdesk has a connector (which fortunately is not Premium) with a number of options that may be useful to you. I am not familiar with the applicaiton, so cannot comment further in this regard.

As for getting data from your Portal, if possible at all, you will probably need to write a custom connector for this.

Also, you might want to re-consider Excel as a data source if you have access to SharePoint Lists as it has quite significant limitations.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Quick Links

Leaderboard > Power Apps