Answered

Use variable in collection instead of column name

(0) Share

Report

Posted on by hadimarashy

I have a collection of 70 items, and I want to use the same text_input to update them all. Currently, on my save button on select I am using a if statement which is very long.

If(
temp_category = "boundary_hoarding",
Patch(
temp_site_weekly_inspection,
First(temp_site_weekly_inspection),
{boundary_hoarding_comment: view_comment_text_input.Text}
);,
temp_category = "welfare_facilities",
Patch(
temp_site_weekly_inspection,
First(temp_site_weekly_inspection),
{welfare_facilities_comment: view_comment_text_input.Text}
);
);

However, I was wondering if it possible to use my temp_category value instead of column name to update the right field.

Patch(
temp_site_weekly_inspection,
First(temp_site_weekly_inspection),
{temp_category: view_comment_text_input.Text}

But, I get the following error "The function 'Patch' has some invalid argument.

Thanks in advance for any suggestions.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Unfortunately, Power Apps does not support dynamic access to column names through variables - the service needs to read the schema of the table & column prior to runtime to work correctly.

If you are finding this code cumbersome to use in your app, consider moving it to a Power Automate flow to perform this update. You can pass a single argument to a flow, but use that argument multiple times within your flow.

Hope that helps,

Bryan

Was this reply helpful? Yes No
hadimarashy 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your help, I am going to use a flow.

Was this reply helpful? Yes No