Solved: Select multiple items in gallery and have each sav...

Kristi2 · ‎05-16-2024

I have a gallery looking at a dummy SharePoint list (hence the random names) which I've set up to select items using a check box, can select and deselect all and has an item count.

I have an HTML Text field that displays what the entire document would look like as a PDF, and have a flow that is working, kind of, when selecting the PDF button. The issue is my flow is only running for the first selected item multiple times, instead of running for each individual item selected. Not sure if it's something to do with the HTML or the PDF Test button, but here's all of the info for those fields:

HTML:

"<!DOCTYPE html>

<html>

<head>

<style>

table, th, td {

border: 1px solid black;

border-collapse: collapse;

}

th, td {

padding: 15px;

}

</style>

</head>

<body>

<h2 style='text-align:center;font-family:verdana'>Audit the Auditor - SRG</h2>

<h3 style='text-align:center;font-family:verdana'> " & galAllAudits.Selected.'Audit Date' & "</h3>

<th>Supervisor/Coach</th>

</tr>

<td style='text-align:center;'> " & galAllAudits.Selected.'Sup/Coach' & "</td>

<td style='text-align:center;'> " & galAllAudits.Selected.CCR & "</td>

<td style='text-align:center;'> " & galAllAudits.Selected.'UCID/CEC' & " </td>

</tr>

</table>

<th>Rating</th>

<th>Overall</th>

</tr>

<td style='text-align:center;'> " & galAllAudits.Selected.Rating.Value & " </td>

<td style='text-align:center;'> " & galAllAudits.Selected.Overall.Value & " </td>

</tr>

</table>

<th>Requirements</th>

<th>Audit</th>

<th>Original</th>

</tr>

<tr>

<th>Accountability</th>

<td style='text-align:center;'>" & galAllAudits.Selected.Accountability.Value & "</td>

<td style='text-align:center;'>" & galAllAudits.Selected.'Acc Orig'.Value & "</td>

</tr>

<tr>

<th>Proactive Communication</th>

<td style='text-align:center;'>" & galAllAudits.Selected.'Proactive Communication'.Value & "</td>

<td style='text-align:center;'>" & galAllAudits.Selected.'PC Orig'.Value & "</td>

</tr>

<tr>

<th>Timely Feedback</th>

<td style='text-align:center;'>" & galAllAudits.Selected.'Timely Feedback'.Value & "</td>

<td style='text-align:center;'>" & galAllAudits.Selected.'TF Orig'.Value & "</td>

</tr>

</table>

<th>Positive Feedback</th>

<th>Opportunity Feedback</th>

</tr>

<td style='text-align:center;'>" & galAllAudits.Selected.'Positive Feedback' & "</td>

<td style='text-align:center;'>" & galAllAudits.Selected.'Opportunity Feedback' & "</td>

</tr>

</table>

</body>

"

PDF Test Button:

ForAll(Filter(galAllAudits.AllItems,Checkbox3.Value) As AUDITPDF, PDFTest.Run(HtmlText3.HtmlText))

So if I were to select the PDF Test button with the screenshot above, it would only run my flow for the Merry Pippin item in the gallery two times. The flow is working as it should otherwise, which makes me think it's something in Power Apps. I'm hoping it's just some funky formula for the PDF Test button, but any help would be appreciated!

Wade_Wilson · ‎05-19-2024

Hey @Kristi2 Your CheckBox formula looks correct

I was wondering how your HTML label is going to render all the values from each record in `colData` when passing it to the flow. Since you are getting data from `galAllAudits.Selected` for the HTML label, it will only return a single record from `galAllAudits` (specifically, the last selected record from the checkbox). This seems to be why you are not getting all the selected PDFs.

My suggestion is to put all the HTML formatting in a Compose action within your PDF flow. Pass all the values from `colData` by making it a parameter from the flow trigger and then use them dynamically in the HTML of the Compose action. This way, you won't need to remove the HTML label from the app, as you mentioned you are using it for preview.

For Ex.

Create parameters in flow:

Bind data in HTML:

Let me know if its worked.

If it did please accept it as solution ✅ and give it a thumbs up👍 so others can get help in the community.

View solution in original post

Wade_Wilson · ‎05-16-2024

I think your HTML label is not not having multiple selected values from your gallery

My suggestion is to write HTML in compose action in flow and pass all the required parameters from app into the flow and use dynamic values by creating parameters for all your required field to make pdf.

Also use collection to collect selected items from gallery,

onCheck of your check box:

Collect(
collectioName,
{

FieldName: ThisItem.ID

//Add mode fields if needs.

}
)

To remove/unselect items from Collection,

onUncheck of check box,

Remove(
collectioName,
LookUp(
collectioName,
Fieldname = ThisItem.ID
)
)

you pdf button formula should be look kinda like this:

ForAll(collectioName , PDFTest.Run(Field1,Field2,Field3,Field4,Field5....))

Accept this as solution ✔️ if this approach worked for you.

Kristi2 · ‎05-19-2024

Thank you @Wade_Wilson

The oncheck and onuncheck options for the button are as follows:

OnCheck: Collect(colData,ThisItem)

OnUncheck: RemoveIf(colData, ID = ThisItem.ID)

And that's how I'm getting the total count, and also have the Check All option to check and uncheck everything in the gallery, so it seems to be functioning appropriately. I figured it must be something in my HTML or Button. I changed the OnSelect on the button to be:

ForAll(colData, PDFTest.Run(HtmlText3.HtmlText))

Unfortunately, that still is only running the selected item in the gallery multiple times instead of running it for each item with a checkmark in the gallery. The HTML is written in a HtmlText item so I can preview the PDF in PowerApps, which is why the button is just saying to run the HtmlText3. Can you describe more what you're saying to do with the HTML? You're saying to put all of the HTML into the Flow instead of in the PowerApp? I have only had instances where I've had HTML in the PowerApp so any assistance or references for how to put it in the Flow would be appreciated. Thanks so much!

Wade_Wilson · ‎05-19-2024

Hey @Kristi2 Your CheckBox formula looks correct

I was wondering how your HTML label is going to render all the values from each record in `colData` when passing it to the flow. Since you are getting data from `galAllAudits.Selected` for the HTML label, it will only return a single record from `galAllAudits` (specifically, the last selected record from the checkbox). This seems to be why you are not getting all the selected PDFs.

My suggestion is to put all the HTML formatting in a Compose action within your PDF flow. Pass all the values from `colData` by making it a parameter from the flow trigger and then use them dynamically in the HTML of the Compose action. This way, you won't need to remove the HTML label from the app, as you mentioned you are using it for preview.

For Ex.

Create parameters in flow:

Bind data in HTML:

Let me know if its worked.

If it did please accept it as solution ✅ and give it a thumbs up👍 so others can get help in the community.

Kristi2 · ‎05-20-2024

@Wade_Wilson Thank you so much! I'm just running into one issue maybe you'd be familiar with, otherwise it's working like a champ! So I added in all of the parameters and created the HTML compose with all of the parameters:

On the button in Power Apps I've updated it with the new flow and called out all of the parameters as well. The issue is I'm getting the attached error because of the Audit Date, which is included in the File Name so I need that date in there. The Audit Date is defaulted to "Today's Date" in the list for the Power App, but it's not a field they can select in the front end of the app. Do you know of any way to change the format to match what Power Automate needs? I tried to Google and Chat GPT it but not getting very far with it.

But when I take out the Audit Date and just have Text as a Parameter, it does work so I'm selecting what you suggested as the solution 🙂 Thanks so much!

Wade_Wilson · ‎05-20-2024

Hello @Kristi2

I'm thrilled to hear that my solution was able to help you out! It's always great to know that I could make a positive impact.

Regarding the issue you're facing now,

You can simply change the parameter type to text instead of date and time, then directly pass it as a string from Power Apps to Power Automate.

Additionally, since you mentioned that the Audit Date corresponds to the date of PDF creation, you can utilize the `date` function within your HTML in Power Automate. You can achieve this by using utcnow() and formatting it as per your requirement.

// as an example, the result could be '2022-03-15'
formatDateTime(utcNow(),'yyyy-MM-dd')

Thanks

Kristi2 · ‎05-21-2024

@Wade_Wilson again, super helpful! I did a little bit more Chat GPT because some of this was going over my head. I ended up doing as you said and changed the Parameter to Text in the flow. Then on the button in the Power App I added the following before the ForAll:

Set('Audit Date', Today());

Set(formattedDate, Text('Audit Date', "yyyy-mm-dd"));

I wasn't sure how it would turn out, but it kept the mm-dd-yyyy format for the PDF and the file name, somehow haha sometimes I don't understand how things work but it did, and still passed through to Power Automate and is running the flow perfectly. Thank you so very much!

Select multiple items in gallery and have each save as an individual PDF

Helpful resources

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

Updates to Transitions in the Power Platform Communities