Share via

Sharepoint List - autofill column based on another list? with Power Automate?

Anonymous
2022-01-10T22:33:10+00:00

Hello,

I've been scratching my head for hours trying to solve what is probably an easy workaround on Sharepoint List.

I am trying to recreate a "form" I have on excel onto Sharepoint List.

Here is the excel:

Sheet 1 is sort of like a form. In Green column C is where answers are to be added.

C4 and C5 in grey are auto-filled based on C2 (departure date) by VLOOKUP Sheet 2

Here is sheet 2

Any help will be much appreciated. I've spent hours trying to figure out functions in sharepoint list, power apps and power automate but in vain,

Thank you!

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-11T06:40:12+00:00

    Hi FrancoisCi，

    Thanks for posting in the community.

    According to your description, my understanding is that you want to create a Workbook for users to upload related information and store it in a SharePoint list

    If my understanding is right, you can refer to this post：Solved: Update Sharepoint List From Excel File - Power Platform Community (microsoft.com)

    If you have more concerns about updating Sharepoint List From Excel File in PowerApps, since we have a specific channel Microsoft Power Apps Community coping with building Power Apps questions, I suggest you post a new thread there for expert help.

    Thanks for your understanding.

    Tin

    0 comments
  2. Anonymous
    2022-01-11T16:32:30+00:00

    Hi,

    That's not exactly what I'm looking for.

    I'm trying to replicate what is currently working with that excel workbook with two sheets (in original post) in SharePoint List.

    In short, I want columns of a Sharepoint List to automatically update/fill when some of the other column are filled...based on static date that resides somewhere else (sharepoint or excel)

    0 comments
  3. Anonymous
    2022-01-13T10:03:00+00:00

    Hi FrancoisCi，

    Thank you for your reply. I'm sorry that the information I found earlier didn't help you.

    You mentioned that you want to automate updating the data in SharePoint columns, so I recommend you to use Power Automate for your purpose.  

    To avoid sharing any incorrect information, it’s recommended to post your question inthe Power Automate Community for a better help. Sorry that our community doesn’t focus on the questions about Power Automate.

    Thank you for your understanding and efforts.

    Best Regards,

    Tin

    0 comments