Unanswered

Patching using a collection separated by commas?

(0) Share

Report

Posted on by broski1212

I am running a collection that is pulling a list of tags separated by commas from a database. I have a button in my PowerApp that I would like to run the following onselection:

1) run the collection

2) patch that column with the existing tags (that are separated by commas) plus one additional tag that I would like it to add to the list.

My code currently looks like this:

ClearCollect(Tags,LookUp(Active,ID = DataTable2_2.Selected.projectid).psa_tags); (this is to pull the correct tags based on ID)

ClearCollect(UpdatedTags, LaunchTags, ",Awareness"); (here im trying to add an 'Awareness' tag to the list of existing tags

Patch(
Activities
LookUp(
'Activities',
id = AssignItem.id
),
{psa_tags: UpdatedTags}
)

My issue is that the Patch function is running an error, this is because the UpdatedTags collection isnt collecting as a string. Its collecting as an object plus my text entry. Is there a way to collect the tags from the DB, add my tag to the string with an additional comma, and patch the column with my tag added?

Thanks for the help!

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @broski1212 ,
If I am reading your requirements correctly, you want to
Get the tags of an existing record
Add , Awareness to them
Patch them back updated
Try this
UpdateIf( Activities LookUp( 'Activities', id = AssignItem.id ), {psa_tags: psa_tags & ", Awareness"} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
broski1212 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @WarrenBelz

Thanks for the help. This code ran me an "Invalid argument type (record). Expected boolean value instead" & "The function UpdateIf has some invalid arguments"

Ive never used the updateif function before. Its looking like the fact that the existing tags record is returning a record as opposed to a string might be the issue? Would really appreciate some guidance here.

Thanks!
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @broski1212 ,
I actually tested the syntax on a test list with numeric identifiers and a Multiple Lines of Text field and it worked as expected.
I cannot see your data, but there are only three items for you to check:
Activites.id should match and be the same type as AssignItem.id (I assume numeric).
Activities.psa_tags needs to be Text (single or multiple)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @broski1212 ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.