Hi, i had any problems, for example, in the power automate, I can´t to assig "string" type to the "Initialize variable" Object. I had to put in the "compose" object the next code: concat('[', replace( replace( join(variables('MS_ARTICULOS_2'),','), '[',''), ']',''),']') with this, in power app, don´t show a error in the PARSEJSON.
Thank you so much for this video! Is there any reason why this would be taking a long time to load into PowerApps? I checked the flow itself and that is taking about 10 seconds to run, but calling the function to load the data into PowerApps is taking FOREVER and often is crashing the app. Any tips to cut down on the load time?
this is quite simple to add brackets and the beginning and the end: concat('[', concat( replace(replace(variables('varDataAsString'),'[',''),']',''),']' ))
Hello . Thanks for material - based on that i was able to create sucessfully Power automate flow and then read data in Power apps via on select button ( instead of ID i am using mail , and under ''vrCustomerRecords'' it reads correctly mails from my Power BI report. ) . However later i do not have option : ,, Parse JSON function and untyped objects ,, available in settings. Could it be a problem ?...when i use ,, collData on properties for Gallery , it shows me no data then . Thanks in advance for response.
This flow will work for any user other than me? I mean, if I share my App to other users but not share my PowerBI dataset, they will be able to query my dataset?
Hi DSTechMirror, insightful video. How do I filter the data in the power BI dataset, i tried taking an input from the Power Apps and passing it into to the DAX formula, however I am running into an error 502 code in Power Apps. Could you make a video on this as well?
My friend you are true hero. Thank you so much.
Glad it helped
Hi, i had any problems, for example, in the power automate, I can´t to assig "string" type to the "Initialize variable" Object. I had to put in the "compose" object the next code:
concat('[',
replace(
replace(
join(variables('MS_ARTICULOS_2'),','),
'[',''),
']',''),']')
with this, in power app, don´t show a error in the PARSEJSON.
Thank you so much for this video! Is there any reason why this would be taking a long time to load into PowerApps? I checked the flow itself and that is taking about 10 seconds to run, but calling the function to load the data into PowerApps is taking FOREVER and often is crashing the app. Any tips to cut down on the load time?
meu caro, você realmente fez a diferença hoje pra mim. Obrigado!
Glad to hear!!
Very helpful. If you have lots of columns just replace the brackets with nothing.
replace(replace(variables('myVariable'),'[',''),']','')
That is actually a little messy, because then you have to add back the [ at the start and the ] at the end of the collection for the parser to work.
@@rodrsturge663 Im bringing like 30 columns from my pbi dataset, do i need to do the replace function for every single one of them? :O
this is quite simple to add brackets and the beginning and the end:
concat('[',
concat(
replace(replace(variables('varDataAsString'),'[',''),']',''),']'
))
Hello . Thanks for material - based on that i was able to create sucessfully Power automate flow and then read data in Power apps via on select button ( instead of ID i am using mail , and under ''vrCustomerRecords'' it reads correctly mails from my Power BI report. ) . However later i do not have option : ,, Parse JSON function and untyped objects ,, available in settings. Could it be a problem ?...when i use ,, collData on properties for Gallery , it shows me no data then . Thanks in advance for response.
thanks for the informative video!
btw is there any way to store the data coming here to a new /existing sharepoint list ?
do we have to make the triggers separately ? I couldnt find the powerapps trigger.
Are there a límit of rows to return data?
This flow will work for any user other than me? I mean, if I share my App to other users but not share my PowerBI dataset, they will be able to query my dataset?
my data type "Table"....is it possible to work with this format?
Can you please upload a video showing how to use an edit form in Power Apps with a Power BI dataset?
Wow, thank you!
You're welcome!
Great content, thanks for sharing
Amazing! Thanks
Thank you!
Hi DSTechMirror, insightful video.
How do I filter the data in the power BI dataset, i tried taking an input from the Power Apps and passing it into to the DAX formula, however I am running into an error 502 code in Power Apps. Could you make a video on this as well?
Thank you🎉❤
Nice!
Replace [ with '' and ] with ''