this is quite simple to add brackets and the beginning and the end: concat('[', concat( replace(replace(variables('varDataAsString'),'[',''),']',''),']' ))
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.
Many thanks for this tutorial! For the most part, this worked for me, but I found that my dataset is returning to PowerApps with a LOT of empty rows. Do you have any suggestions for getting the empty rows out? I attempted to filter these out in my PowerBI query but this didn’t change the results. Thank you!
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
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'),'[',''),']',''),']'
))
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.
meu caro, você realmente fez a diferença hoje pra mim. Obrigado!
Glad to hear!!
Many thanks for this tutorial! For the most part, this worked for me, but I found that my dataset is returning to PowerApps with a LOT of empty rows. Do you have any suggestions for getting the empty rows out? I attempted to filter these out in my PowerBI query but this didn’t change the results. Thank you!
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.
do we have to make the triggers separately ? I couldnt find the powerapps trigger.
Can you please upload a video showing how to use an edit form in Power Apps with a Power BI dataset?
thanks for the informative video!
btw is there any way to store the data coming here to a new /existing sharepoint list ?
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?
Wow, thank you!
You're welcome!
my data type "Table"....is it possible to work with this format?
Great content, thanks for sharing
Thank you🎉❤
Amazing! Thanks
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 ''