cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AVTS
Post Patron
Post Patron

Need to retrieve multiple columns from different types datasource

Hi Team,

 

I have dataverse which has multiple tables also i have custom connectors which connected via flow

 

Datasource : Dailyinventory

Dataverse Table name : Material Master

 

Flow details : PowerApp -> GetCurrentStock

Collection name : mango

Table follows , materialno,qty

 

 

Excisting datasource formula follows,

 

With( {TheTable:Filter(
ShowColumns(Dailyinventory,"crf99_sno","crf99_materialdesc","crf99_materialno","createdon","crf99_bbd","crf99_qty"),DateDiff(createdon, Today(),Days) =0)},
ShowColumns(AddColumns(GroupBy(TheTable,"crf99_materialdesc","crf99_materialno","NewGroup"),

"Created On",Last(NewGroup).createdon,
"bbd",Last(NewGroup).crf99_bbd,
"Qty",Sum(NewGroup,crf99_qty)),"Created On","bbd","crf99_materialdesc","crf99_materialno","Qty"))

 

 

AVTS_0-1621629198044.png

 

In pointer no i need to bring the qty for same material from custom connecter collection name mango.

 

How to acheive this

 

i tried to add this command with otherqty onselect but no luck

 

Dailyinventory.Materialno=("mango".material)

 

can anyone direct me ..

3 REPLIES 3
TheRobRush
Super User
Super User

***Edit question below was regarding original post, which appears to have completely changed to a new issue

 

Not 100% clear what it is you are trying to count. Is it how many records were created on that day, or summing values of a certain column.

_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!

Thank you for responding quickly.i got the answer for previous one . But above one need some direction

AVTS
Post Patron
Post Patron

Friends can anyone check and revert with your advise.

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,332)