Get values from a sharepoint list avoiding existing records in cells

(0) Share

Report

Posted on by MikeAA

Hi everybody.

I have a sharepoint list like this:

ID	Group	Table
1	AME	NAME
2	EUR	CURRENT_HOTEL
3	AME	CANCELS
4	EUR	CANCELS
5	UK	CURRENT_HOTEL
6	USA	CURRENT_HOTEL

and I would like to implement a Power Automate process that allows me to generate an HTML table that collects the values of the Sharepoint list with the following format:

Table	Group
NAME	AME
CURRENT_HOTEL	EUR, UK, USA
CANCELS	AME, EUR

I really appreciate some help to resolve this issue

Categories:

General topics

All responses (2)

Answers (0)

Sort by

Rhiassuring 8,692 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Well, I achieved it doing it this way, but I'm not sure it's the best or only way:

The variables: a string for each CURRENT_HOTEL, CANCELS, and NAME -- then an array for "New Array".

Then a Get Items for each of those three, hard-coded into a filter query. (If you had different table names each time, that would be a different story...)

Then, an Apply to Each where we append the filtered Get Items into its respective string variable.

Then we just build the new array by appending lines to the array:

Which then lets us finally use our array to create the HTML table:
MikeAA 42 on at

Like
a
(1)

Report
Copy link

Link copied!

hi @Rhiassuring it´s terrific all that you did.
I'm going to see how I can implement it because as you mentioned in parentheses (I had different table names each time, that would be a different story...).