Answered

On each ForAll, Update Collection with Custom Connector parameters

(0) Share

Report

Posted on by jdlevms

Hi! Hoping you can assist.

I have a custom API connector that is added to a collection passing a CompanyID parameter. This is working perfectly. What I'm trying to do is add the "CompanyID" parameter that is being passed to the "CompanyID" in the new "findings" collection as it iterates. Here's the formula that I currently have. I have hardcoded the 1, but need the correct CompanyID. Any thoughts?

ForAll(
clientlist,
Collect(
findings,
DataConnect.GetPGroups({CompanyID: Value(CompanyID)})
); UpdateIf(findings,IsEmpty(CompanyID) = true,{CompanyID: 1})

2021-05-23 13_16_27-Master Agent Tool - Saved (Unpublished) - Power Apps.png

)

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@jdlevms Try this,
ForAll( clientlist As myclientlist, Collect( findings, AddColumns(DataConnect.GetPGroups({CompanyID: Value(myclientlist.CompanyID)}), "CompanyID", CompanyID )
Now the collection findings should have a column "CompanyID". Hope this helps!
Verified answer

jdlevms 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, @CNT. That approach may have worked with some tweaking, but I was able to get it figured out. I needed to update the UpdateIF to add the clientlist[@CompanyID] since companyID exist in both collections. Here is the final code if anyone runs into the same challenge

ForAll(clientlist,Collect(findings,DataConnect.GetPGroups({CompanyID:Value(CompanyID),Status:1}));
UpdateIf(findings,IsBlank(CompanyID)=true,{CompanyID: clientlist[@CompanyID]}))
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@jdlevms I new this situation where CompanyID exists in both places. That's why I had use the As quantifier, clientlist As myclientlist. Did you try that? Anyway, glad it works!

Please remember to give a 👍 and accept the solution as it will help others in the future.