Unanswered

Take JSON values to Lookup value in SharePoint List and Create a Table

(0) Share

Report

Posted on by ZeeITGuy

Hi Everyone!

Long time Power Automate user, first time poster! Generally I can find an answer to what I'm doing online but I'm stuck.

I have an equipment inventory list in SharePoint that is connected to a PowerApp. Our staff can scan the piece of equipment and have certain fields updated based on the button (time scanned, assigned to, status, etc.).

I've now been asked to have a report generated when items are returned. At present, I have setup the button in Power Apps to scan barcodes into a collection. They then hit another button that submits the data in the collection in JSON format to Power Automate. Sample of the data is:

[
{
"BarcodeInfo": "IT-TEST-1"
},
{
"BarcodeInfo": "IT-TEST-2"
},
{
"BarcodeInfo": "IT-TEST-3"
},
{
"BarcodeInfo": "IT-TEST-4"
},
{
"BarcodeInfo": "IT-TEST-5"
}
]

This is where I get stuck. Next step (in my mind - please advise if there is an alternative more effective way) is to run "Get Items" from the SharePoint list for each Barcode value. From there, put the BarcodeInfo (correlates to the Equipment ID in the SP list) and collected information from the Get Items action into a table. I can then put that table into my template report document, pdf it, save it to our repo and email it out.

Any advice on how I can get the info and append it to a table? Should I use an Excel online table? Or an HTML table?

Thank you Community!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Gopala_Krishna 1,495 on at

Like (0)

Report
Copy link

Link copied!

@ZeeITGuy

You can utilize the create HTML table action , to construct the table output of that would be HTML table structure which you can specify in your documents and pdf it.

In the From you can select the value from the outputs of GET ITEMS action this contains the list of all items in your list with all column information in a structured format.

For column type you can setup to be manual and you can select what columns to include and the corresponding dynamic content to populate in that, if you select automatic it will select all the columns that are coming from the get items output.

This way you can create table add data to it and then utilize it creating reports.

------------------------------------------------------------------------------------------------------------------------

If the information shared helps you please consider giving a thumbs up 👍and mark solution as resolved

Was this reply helpful? Yes No
ZeeITGuy 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response @Gopala_Krishna,

When I do the get items action, I select the field from the JSON and it changes into apply to each:

The result is that I cannot select the items action:

I am looking to filter the table to the list of items from JSON with the additional columns from the SharePoint list. Am I missing a step? Is there an append to table option that I can have the apply to each build upon?

Thanks!

Was this reply helpful? Yes No
Gopala_Krishna 1,495 on at

Like (0)

Report
Copy link

Link copied!

@ZeeITGuy

In this case you can try adding the HTML table action and other actions inside the Apply To Each loop itself.

Once you add the actions inside the loop you would be able to see the output properties of the sharepoint action.

----------------------------------------------------------------------------------------------------------------

If the information shared helps you please consider giving a thumbs up 👍 and mark solution as resolved

Was this reply helpful? Yes No