adding item List data as array in Power Apps

(0) Share

Report

Posted on by NidjoJohnny22

288

Hi everyone,

I have a screenshot of app which is List-data based, and this item has column "Reminders" whereas when user clicks this button, it adds him into an array of User() object emails. So then when I want to do a Flow later on to send auto emails with item data as reminders, it sends to all emails inside. That is the idea, but I don't know how can I append to array in Power Apps?

If somebody has an idea how to do it, please link to arrays of this case or sth.

Thanks in advance!

- Nikola

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

SanmeshG 1,947 Moderator on at

Like (1)

Report

Hi @NidjoJohnny22 ,

Please use a collection to add the email IDs into it. And for Sending Email you can use the SendEmailV2 in PowerApps. Or if you want to send it to Power Automate , send this collection as a JSON , and iterate over it with apply to each to send email to each individual.

If this helps, please give this a thumbs up and accept this as a solution.

Thanks,

Was this reply helpful? Yes No
NidjoJohnny22 288 on at

Like (0)

Report

Hi @SanmeshG, so I should collect the data and put into array? bcz I'd like to save that data into the List

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @NidjoJohnny22 ,

How are you saving the data in SP list , in one single column as JSON(in a multiple lines of text column), then you can just pass the JSON data as a collection and save it in SP list with Patch function.

And then maybe based on your trigger the flow will run and you can parse that JSON and send email.

Was this reply helpful? Yes No
NidjoJohnny22 288 on at

Like (0)

Report

okay I will try that... do you know maybe of some working example for Json?

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (1)

Report

Hi @NidjoJohnny22 ,

Please refer the below screenshots.

Hope this helps!

If this helps , please give this a thumbs up and accept this as a solution.

Thanks,
Sanmesh

Was this reply helpful? Yes No
NidjoJohnny22 288 on at

Like (0)

Report

Hi @SanmeshG , I find this very helpful because I can connect it with other example of collect! I will try it out my way for sure, but before that I wonder, which event can trigger the "collect" function? Does it have to be form submittal or something? Can I use the CB OnChange or some event?

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (1)

Report

@NidjoJohnny22 ,
This formula is written on the onselect property on the check icon in the gallery

Was this reply helpful? Yes No
NidjoJohnny22 288 on at

Like (0)

Report

@SanmeshG Thank you for info, I have just tried it in the gallery and it works perfectly fine!

Still going to investigate about forms and such options. I belive I will have to use the LastSubmit there to get access to data which I need...

Was this reply helpful? Yes No