#TipOfTheWeek – #PowerAutomate

In case you are using a ‘vlookup’ column type in SharePoint list -any kind of list-, consider that you cannot bring multi-lineal cells into the first list imported from the second list, as there are few limitations (only ‘single line of text’, ‘number’ or ‘date’ type cells are supported).

My “out-of-the-box” solution for this situation is to create a simple data model in Power BI -sourcing the multiple SharePoint lists- and create a relationship with the tables, then multi-line cells are supported.

Thank you