Share via

How to auto-populate 9 other fields from our portal and an appl like Freshdesk when you input information into one field?

Tallmale 20 Reputation points
2025-06-19T07:42:49.3866667+00:00

Hi everyone,

I want to create an excel sheet with 10 different fields so that when I add data to one specific field it will automatically auto-populate the other fields grabbing specific product information from that one product.

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.

I need the information that auto-populates the other 9 fields to be imported from our portal and an app like Freshdesk. I dont need whole tables imported just single items related to the first bit of product information I inputed into 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?

Microsoft 365 and Office | Excel | For business | Windows
0 comments
Accepted answer
  1. Tammy-Ng 390 Reputation points Microsoft External Staff Moderator
    2025-06-19T10:05:16.3733333+00:00

    Dear Tallmale

    Thank you for posting your question in the Microsoft Q&A forum.

    From what you’ve shared, it sounds like you’re looking for a faster way to fill in product details in Excel, so that when you enter a SKU, the rest of the fields (like color, size, price, etc.) automatically fill in with data from your portal and Freshdesk. That’s a great idea, and I’d love to help point you in the right direction.

     Here are a few suggestions you can try:

    • Use Excel’s “Get Data” feature:  In Excel, go to Data > Get Data > From Web to connect to your data source.

    image

    However, there isn’t a direct way to import only specific information to auto-populate those fields in Excel without bringing in the full dataset or building a custom solution using tools like Power Query, Power Automate

    While there’s no built-in way to pull in just specific fields without bringing in the full dataset, tools like Power Query or Power Automate can help you build a custom solution. These tools let you fetch only the fields you need, making your Excel sheet much more efficient and user-friendly

    That said, since we don’t have access to your internal systems, we’re limited in how much we can assist with the setup. For more advanced help, I recommend posting your question in the Power Platform Community, where experts can provide you with more helpful support.

    We truly appreciate your understanding, and we’re here if you have any further questions or need clarification on the steps above.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".     

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tallmale 20 Reputation points
    2025-06-21T16:38:10.42+00:00

    Hi Tammy,

    Thank you for your detailed response.

    What section/category should I post this question in the Power Platform Community?

    Many thanks.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.