Showing results for 
Search instead for 
Did you mean: 
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)},

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





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




can anyone direct me ..

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

Post Patron
Post Patron

Friends can anyone check and revert with your advise.

Helpful resources

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)