Importing an Excel Column with Multiple Values into a Multi Choice Field with Power Automate

Подписаться 7 тыс.

Просмотров 7 тыс.

50% 1

Hi Everyone,
In this video, you will learn how to use Power Automate to efficiently import an Excel column with multiple values into a Multi Choice field in Microsoft SharePoint. This automation can save you time and reduce errors when transferring data from Excel to SharePoint.
We'll walk you through the step-by-step process of setting up a Power Automate flow that converts the multiple values in your Excel column into a format that SharePoint can recognize and populate into a Multi Choice field. We'll also cover some common issues and troubleshooting tips to help you get the most out of this automation.
Whether you're a seasoned SharePoint user or new to Power Automate, this video will provide valuable insights and practical guidance on how to streamline your data transfer process and improve your overall workflow.
✨Support My Channel✨
If you enjoy my content and would like to support my work, consider buying me a coffee! Your support helps me create more videos and keep the channel going. ☕💖
buymeacoffee.c...
🪙BTC🪙: 3LpmcBaJB537RweJu2tRjSqT6NhnQDDBWy
⛓️ETH⛓️: 0xbAEb6d6Df7CE5cfC55797B3133342e165B78A444
🐕DOGE🐕: DNKNUduorzBWMJ4XTSRqUSsUKk3ZiehHin
#powerautomate #sharepoint #excel

Опубликовано:

14 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 12

@brauliojiomeke 8 месяцев назад

You saved my life today! Thanks a lot!

@michaelalex2322 8 месяцев назад

Glad to hear that!

@robinend8277 8 месяцев назад

Hey Michael, thanks for the helpful video. I may have found an easier method as well. When your divider in the excel column is ";#" instead of "," (which you could do by search and replace) If you then import Excel > set column type "Choice" Go to the imported Sharepointlist > go to column > column settings > Edit > more options > allow multiple choices > now create each individual choice (Just as in the video) This way - for me at least - Sharepoint detects the ;# as individual choices and automatically writes them as such

@paigewitucki1134 7 месяцев назад

THANK YOU FOR THIS

@kam5333 2 месяца назад

Would this work for lookups?

@TheRimeME 5 дней назад

This saved me A LOT OF WORK. Thanks a lot bro! I may have found one more thing - maybe someone will find it useful: If you're only interested in the visual aspect (each choice looking like a pill), Instead of adding all choices manually, you can add the first one and change it's color any color. SharePoint will automatically format ALL choices to look like "pills".

@marcinlewanczuk1885 7 месяцев назад

Very useful video, but you could have mentioned the mistakes you made at the beginning, because I also made them together with you. But it doesn't change the fact that it was very useful to me. Thank you

@angelarutherford3318 Месяц назад

What if you want to update a SharePoint list value?

@jszclaptone4042 Год назад

Hi Michael, Thx u so much for the video, I have am problem, How can I create, update, and delete a Sharepoint list from an excel online, all the videos I watching in RU-vid only create and update from the excel but do not delete the row that is selected, you can help me, thx u!

@SteveGwilliam 11 месяцев назад

Hi Michael, need some help and you seem to know alot about sharepoint.. Im trying to get the total sum on the Parent folder of the Child folder within but googled everywhere, but some of your videos got close.. Thanks